I like the sound of some of those mods - care to suggest some specifically and perhaps where to get them?
Sorry, I was out of town for a few days. Don't have much time to write about all of my favorites, but here's a list that details some of the best out there and where to get them:
http://aelius28.googlepages.com/homeSome of my favorites:
Oscuro's Oblivion Overhaul
Expanded Hotkeys and Spell Delete
Deadly Reflex 3
Thieves Arsenal
Tamriel NPCs Revamped
Natural Environments
Unique Landscapes
Martigen's Monster Mod
Operation Optimization (greatly improves FPS)
Bluesteel's Landscape LOD NormalMap Fix
Qarl's Textures
Illumination Within Revived
And of course <selfless plug
>, anything with PJ in front of the name like PJ's Spell Compendium, PJ's Lightning strikes before storms, and my favorite PJ's Disco spell:
http://www.tessource.net/files/file.php?id=5272