It's the closest thing Skyrim can come to 'Reign of Fire' the movie. You're now fighting dragons who actually have sense of self-preservation. It makes the dragons seem more like dragons.
The most polished mod of Apollodown's is probably DCO (Dragon Combat Overhaul). Any NPC who pathed wrong or any mods that slightly conflicted (like city overhauls with new navmeshing) would cause a CTD, freeze, or simply fire incorrectly and stalemate an event. Like a house of cards waiting to collapse. Unfortunately the original bugginess became exponential with the amount of new features piled on top of it.
What Apollodown did was quite an impressive feat and took an insane amount of patience to mod and test. They have to modify work that (at its core) was buggy to begin with. CWO suffers from the same issues as other Civil War mods.