Skyrim Developers Kit will come out in January. The mods coming after that will be much more in-depth and fun to play. I remember some of the later Oblivion mods being as good as the game itself.
It'll be fun to see the mods that will come out alright.
No doubt there'll be ones where the Holds all fight against each other and you can dominate the rest etc, or a proper re-hash of RTS even.