Great article there, though I believe there are actually quite a few other mods that would deserve spotlight like this just for the shear enormity of how they can change the game and make you want to replay it the umpteenth time. For example, SkyRE (aka. Skyrim Redone, http://skyrim.nexusmods.com/mods/9286) changes all the skills and adds a plethora of new elements and tweaks into the game, so it could be said it is a reason by itself to replay the entire game from beginning to end just to see the changes.
The mod I'm currently waiting for is this: http://skyrim.nexusmods.com/mods/37216/?
It is a re-haul of the civil war where you actually has to take over the cities themselves, and if you don't try hard enough (don't follow orders, don't show up at the sieges, etc.), your side can actually
lose the war! Once finished, that mod will be enough to make me re-play the game the fourth time.
Now, the only mod I am still missing would be one that makes all the NPCs react properly to my character's magnificent presence (like, say, not treating their Thane like a random beggar or the Jarls actually recognizing the Dragonborn when he walks up to them in full dragonbone armor and Daedric weapons) and make the dumb bandits run away instead of trying to fight me, and Skyrim would be perfect. For every other issue, we already have mods.