Thanks to Mr. Josh Sawyer for sharing an Adoring Fan at Jump Rock video I've decided I want to play this again. Can people recommend me some awesome mods? I actually think I have my old disk with mods from '05 but maybe there are some new good ones? Any visual mods I must be made aware of?

Depends on what you're looking for, really.

More NPC's, pretty landscapes, anything like Project Nevada but for Oblivion?

I'll have to see where my original mod disk is and see what's on there.

I do remember having fun with a lockpick mold mod.

I'm also installing Knights of the Nine and Shivering Isles...and yes, I will be installing Horse Armor.

Landscapes, look into Unique Landscapes.

I'm gonna just paste the recent thread for the similar topic then you can go from there: http://www.gamesas.com/topic/1395654-new-to-mods/%C2%A0%C2%A0 All the popular mods are either at Nexus or TESAlliance.org AFAIK.

Some are here: http://www.darkcreations.org/forums/files/

And the download speeds can be better than on the Nexus.