Strazdas said:
Further, the Kit will hook into Valve's Steam Workshop which will allow modders to share and rate other people's mods much easier than collating them from various mod websites.
Why do you have to kill your fansites
I doubt that this Stam integration will kill Nexus. It's too well-established and has too big of a loyal community to die just because Steam will host mods for Skyrim. For all we know, the Steam-hosted mods might be limited to a certain size, screened for content (not necessarily obscene or inappropriate content, it could also be screened for copyrighted content or just things that the censors don't like), and lack the update and feedback mechanisms that Nexus has.
If any of that happens, you can be sure that Nexus will still host mods. It's just a much more convinient place for them. Heck, even if none of that happens, Nexus should still be up and running.
Now, this whole Steam-mod connection sounds cool, and I might even browse what's available there when it's active, but I think that I'll stick with Nexus.
OP: Good to see that the CK's on the way. Also good to see that Bethesda is working on new patches, even though, like it's been said, they could be a tad overzealous in their patching.