Simply what mods that are currently out or will be out in the future(eg, after this post) do you think would go best into a comprehensive graphical overhaul? Provided they could work out the compatibility issues and agree to do it...you can also pick and choose parts of a mod that maybe does a better job in some areas than another you like for other purposes.
-be sure to link to your mod for comparative purposes.

This is far from comprehensive but these are what I would put into it so far. Haven't been playing for awhile too so may be some I am unaware of.

Opticshooter
http://skyrim.nexusmods.com/downloads/file.php?id=13268
http://skyrim.nexusmods.com/downloads/file.php?id=3385
http://skyrim.nexusmods.com/downloads/file.php?id=3288
http://skyrim.nexusmods.com/downloads/file.php?id=1598
http://skyrim.nexusmods.com/downloads/file.php?id=4964

Plutoman
http://skyrim.nexusmods.com/downloads/file.php?id=7654

dDefinder1
http://skyrim.nexusmods.com/downloads/file.php?id=60

Brumbek
http://skyrim.nexusmods.com/downloads/file.php?id=8655

Isoku
http://skyrim.nexusmods.com/downloads/file.php?id=2947

Xenius
http://skyrim.nexusmods.com/downloads/file.php?id=2356

Vurt
http://skyrim.nexusmods.com/downloads/file.php?id=141

That is all I got for now. Thoughts?

That's pretty much identical to what I would've picked. Though I'd also use http://skyrim.nexusmods.com/downloads/file.php?id=4307

Oh and http://skyrim.nexusmods.com/downloads/file.php?id=85 for nicer night sky textures. Should be compatible with Realistic Lighting and its add-ons.

Ahh yes, I actually had used that before. Was a good one if you wanted to stick to vanilla hair, which I did as most of the new hairs coming out were too clean and fashionable for my tastes. I have to say that I am using most of those because I have used their Lite versions as I have a fairly mid range PC. I am not using a few of them though but they look rather good.

Well it is more a sounds category but I think http://skyrim.nexusmods.com/downloads/file.php?id=8601 of http://skyrim.nexusmods.com/downloads/file.php?id=10886(both editions that I am aware of at least) are pretty nice.

http://skyrim.nexusmods.com/downloads/file.php?id=3147 looks really nice as well.

So does http://skyrim.nexusmods.com/downloads/file.php?id=85

http://skyrim.nexusmods.com/downloads/file.php?id=11
Next update will be out in the coming week, friday at the latest. Current version still has lots of nice graphics mods for you to find though, but is rather dated. Pretty much your best bet for finding the perfect mix of graphical mods to add to your game. They have forums with mod-reviews and such aswell over at http://forum.step-project.com/

This.