GameSpot shares a running video segment of some of the top Skyrim Mods available, so here to share with you are those top mods (in no particular order)

Lydia Rides to Black Marsh!

Here we carve up some bandits, travel to foreign lands, throw some knives, and put Lydia on a horse.

Dwemer Autoblade 
by Pirate
http://steamcommunity.com/sharedfiles/filedetails/?id=14393

TESV: Journeys: Black Marsh 
by hereiamhereibe2
http://steamcommunity.com/sharedfiles/filedetails/?id=14359

Deadly Combat
by Borgut1337
http://skyrim.nexusmods.com/downloads/file.php?id=5485

Horses for Followers
by Spudgunner
http://steamcommunity.com/sharedfiles/filedetails/?id=13706
http://skyrim.nexusmods.com/downloads/file.php?id=11193

Throwing Knives
by Nez
http://steamcommunity.com/sharedfiles/filedetails/?id=13998
http://skyrim.nexusmods.com/downloads/file.php?id=11875

Skyrim, the Old Republic

 Join the Sith Legions, take a short trip to Oblivion, and raise an army of toys.

Quest: And the Realms of Daedra by ThirteenOranges
http://steamcommunity.com/sharedfiles/filedetails/?id=15308
http://skyrim.nexusmods.com/downloads/file.php?id=12369

Deus Mons by ElDiabs & Daemonjax
http://skyrim.nexusmods.com/downloads/file.php?id=11803

Moon Deathstar (Various Types) by [BlueEye]TerrorKiller
http://steamcommunity.com/id/TerrorKiller/myworkshopfiles

Magicka Sabers by Lord Haun
http://skyrim.nexusmods.com/downloads/file.php?id=3174.

Elvenwood by Nick7575
http://steamcommunity.com/sharedfiles/filedetails/?id=14718
http://skyrim.nexusmods.com/downloads/file.php?id=12025

ColloseusX's Toy Soldiers
http://steamcommunity.com/sharedfiles/filedetails/?id=15376

Lions, Portals and Bears, Oh My!

Testing out the tools of Aperture Science, play with the science of apertures, and wage a land war across all of Skyrim. Also, chickens. The explosive kind.

Portal Gun in Skyrim Alpha v1 by zOmbi880
http://steamcommunity.com/sharedfiles/filedetails/?id=15673
Notes: Weapon found on the ground in Windhelm. Basically a fancy teleportation spell, or like the beginning of Portal when you only have blue. 

Mike's Mystical Mounts
http://steamcommunity.com/sharedfiles/filedetails/?id=15356
http://skyrim.nexusmods.com/downloads/file.php?id=12700
Notes: Talk to Mike the Argonian in front of Whiterun stables. 

Prides of Skyrim by Frank the Fish
http://steamcommunity.com/sharedfiles/filedetails/?id=16012
http://skyrim.nexusmods.com/downloads/file.php?id=12647
Notes: Adds packs of roaming lions to landscape. Really difficult: lions are level 50, and lionesses are level 40. Also includes a bunch of lairs and dens. 

DYNAVISION - Dynamic Depth of Field by Gopher and MyGoodEye
http://skyrim.nexusmods.com/downloads/file.php?id=12525
Notes: Simulates depth of field effects of a 35mm camera lens. Older version gave you a spell to summon gopher, newest version uses special stone outside Riverwood to summon gopher. Talk to dude to adjust settings. Unlike other mods like this, very minimal frame rate impact. 

WARZONES - Civil Unrest by MyGoodEye
http://skyrim.nexusmods.com/downloads/file.php?id=9494
Notes: Recommended by GameSpot user darkmoney52. Basically turns Skyrim into all-out civil war, adding 62 battle zones throughout entire world. Also adds "new scenery and boss-like characters." Battles are dynamic based on factions you've sided with, etc.

Camping with the Exploding Handyman

Here we turn into a dragon, explore a stately manor, dual wield some blacksmith hammers, and do a bit of camping.

The Dragon's Curse [Alpha v2]
by FailCake :D ™
http://steamcommunity.com/sharedfiles/filedetails/?id=12539

Dragon Falls Manor
by Mattcm919
http://steamcommunity.com/sharedfiles/filedetails/?id=13433

Handyman
by Pope Canuckovitch
http://steamcommunity.com/sharedfiles/filedetails/?id=11822

Camping
by LtMattmoo
http://steamcommunity.com/sharedfiles/filedetails/?id=12454

Explosive Chickens
by: The Deann
http://steamcommunity.com/sharedfiles/filedetails/?id=11588

What mods have you seen for Skyrim that are awesome and deserve some recognition?