I don't know of a really definitive list. I did post a gamefaqs thread wherein I inquired about mods and I got a lot of good options there:
http://www.gamefaqs.com/boards/92436...ivion/59453965
aside from that, try this thread: http://forums.bethsoft.com/index.php...vion-mods-faq/ there is a section titled "Where can I find good mods?" that has some links as well as advice.
the only mods that I think are required for everyone no matter what your tastes are:
- Unique Landscapes Compilation. nothing else does what UL Comp does, and the new landscapes are so well-integrated into the old Cyrodiil you won't even realize how much things have changed.
- Oblivion Graphics Extender. a must-have. provides a lot of new shader effects as well as other tweaks for the graphics.
- Oblivion Script Extender. odds are, one of the mods you use will require this - for example, Oblivion Graphics Extender.
- Oblivion XP. this is debatable, since there are other mods that change the leveling system, and to be honest I haven't tried them. I don't feel the need to. this one completely overhauls the leveling system to be XP-based and I can't imagine anything else doing a better job.
- Quick start. I think that's what it's called, anyway - skips the entire beginning dungeon and deposits you right at the sewer gate. oh my god is this ever a time-saver, especially when testing out new mods. must-get! I could recite the beginning dialogue from memory by now, I wish I had discovered this earlier...
there are lots of other mods out there, but there tend to be several major options in each category - I can think of at least four or five magicka mods, for example, and of the most part they will conflict with/overwrite each other so you will need to pick one. experiment, have fun, be prepared to possibly reinstall and start over at least once. I've spent more time modding Oblivion than I care to think about, though I've learned a hell of a lot and have recently installed FCOM, supposedly the most difficult mod to get working correctly. so that's cool.
oh, and piece of advice: install the game to C:/Oblivion. installing into the default directory if you have Vista or windows 7 will just cause headache after headache.
XI Wiki


