Some of the enormous tweaks are already out. Skyrim has oblivions modding community on crack.
Indeed they are. SkyBoost was an interesting one. Thankfully, the devs turned on their compiler optimizations for 1.4. SkyUI I consider essential already.
But what I meant to say, was a lot of people initially think of mods as those things you use to replace a boring set of armour or make yoru favourite weapon stronger (or weaker). The best mods tend to do impressive things instead, like overhaul the leveled lists and spawns for the entire game, add new guilds, make
all the windows transparent, or add whole cities.
The console versions of the game are selling well enough right now that it's obviously an awesome game for console players too. The ones who want to play later on PC aren't going to miss out on anything except maybe a bit of hype, and will have an easier transition once the mod scene has stabilized into some patterns and routines like it eventually did for Morrowind and Oblivion.
I also feel I should mention that sometimes I'm glad most games are cross-platform now. Yes, they don't do as many things when they have to run on consoles, but then I don't have to think so hard about getting the game to run well. Skyrim ran fine on my old computer. If it was PC exclusive I probably would have had issues until I bought my new computer, which I mostly bought for work anyway. As a programmer myself, I like to see long hardware cycles forcing some software optimization.
