http://www.skyrimnexus.com/Just sort by top rated. Some of the gfx mods are awesome (STEP, real ice, etc) and some make things no longer "fit" the scenery. All the mods have comments, I like Tytanis, there's 3 mods by headbomb or something that fix broken items in the game, and broken crafting mechanics. Some of that is all mixed in with Tytanis too.
Also skyrimonline.com
If that ever comes along and looks closer, I'm going to start bombing it with demands that the PvP server have 1 life and full loot.