There seem to be a lot of new Skyrim mods coming out every other day. Mostly cosmetic stuff, but I wouldn't be surprised to see more 'total conversion' style work soon.

I haven't really checked moddb.com since Unreal Tournament 2004 was the big online game, but it seems to be going strong.