For me, these mods are:
- Moonpath to Elsweyr - Where you can travel to Elsweyr. And it's so very pretty.
Here there be Monsters - A mod which puts what are basically Kaiju into the sea of ghosts for some ultra-hard boss battles, as well as adding some ship captains and traumatised survivors
Space Wiking Dwemer Exoskeleton - Because there's nothing more badass than beating up dragons in a robotic exoskeletons and if you say otherwise I will so fight you!
Midas Magic - Technically this one could probably go into the Foundation Mods thread as all it really does is add some new spells; doesn't seem that impressive on the surface, but it makes the cut because one the spells summons angry bees to attack the enemy, and that makes me think of both Eddie Izzard and Bioshock. Eddie Izzard and Bioshock are two good things.
WARZONES - Civil Unrest in Skyrim - Actually gets a proper Civil War going with randomly occurring battles here and there between Stormcloaks and Imperial Legionaries, with the option to tweak how often they happen.