The game has only been out for a short while, and already there are some great mods out. Here are some of my favourites:

FXAA Post Process Injector: This is a great mod that breathes a bit more life into the world of Skyrim by adding some much needed colour to it. There are four presets to choose from, all of which are great. depending on your preference. http://www.skyrimnexus.com/downloads/file.php?id=131

QD Inventory: This is my favourite mod. It completely rebuilds the inventory screen into something much more PC-friendly. I love the game, but Bethesda sure did screw up by making a more console-focused game this time, but this mod goes a big way toward fixing that. The inventory screen is no longer an unwieldy mess! http://www.skyrimnexus.com/downloads/file.php?id=667

No More Blocky Faces: Perhaps my second favourite mod this far, this one does exactly as it's name implies. If the blockiness of the NPC's faces has been annoying you as much as it did me, you will love this mod. http://www.skyrimnexus.com/downloads/file.php?id=30

Enhanced Night Skyrim: A purely aesthetic mod, this one just adds more colour to the stars in the night sky. I think it also adds some real-life constellations. http://www.skyrimnexus.com/downloads/file.php?id=85

Killable Children: :D http://www.skyrimnexus.com/downloads/file.php?id=774

I have begun a YouTube channel in which I'll be posting mod spotlights such as this as well as other Skyrim goodies.

There'll be more videos here

The post-process injector is an amazing mod. It has made my game look awesome, especially on my HD TV. I really recommend that, and the night sky one is cool too. There is a really nice sunlight mod as well.

@CJduke: Agreed. Happen to know the name of that sunlight mod?

@GunslingerPanda: yeah skyrim sunglare http://www.skyrimnexus.com/downloads/file.php?id=116

Isn't it amazing how the Construction Set hasn't even come out yet, but there are already so many great mods?

@CJduke: Thanks.

@President_Barackbar: Yeah, it's crazy. Sounds like most people are just using the Oblivion CK to mod it though.