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