Pretty much any mod that came out after the DLC.... Well at least any decent mod made by a decent modder that does a tiny bit of research before editing locations. I know Servant of the Dawn has a little overlap with Knights of the Nine, but that's because it was there first.
OOO is one of the most popular mods for Oblivion if not
the most popular mod, so of course it works with DLC. It doesn't effect SI though so things will still be mostly vanilla there with just OOO
List of lists:
http://www.gamesas.com/index.php?showtopic=1010109
Check the Toql list, combat list, and texture/visual list(s)
My must haves/recommendations: (excluding Servant of the Dawn I guess, if the overlap bothers you)
For the occasional "What are your must haves?"Mostly quest mods: http://kno.li/i
My favorite quests are:
http://theelderscrolls.info/?go=dlfile&fileid=349 (my most favorite)
http://www.tesnexus.com/modules/members/index.php?id=125368
http://www.tesnexus.com/downloads/file.php?id=21989
http://www.tesnexus.com/downloads/file.php?id=17448
http://www.tesnexus.com/downloads/file.php?id=6977
http://www.tesnexus.com/downloads/file.php?id=6855
Ihttp://www.tesnexus.com/downloads/file.php?id=19591
Gameplay mods:
http://www.tesnexus.com/downloads/file.php?id=25462
http://www.tesnexus.com/downloads/file.php?id=25835
http://www.tesnexus.com/downloads/file.php?id=22894
http://www.tesnexus.com/downloads/file.php?id=25844
http://www.tesnexus.com/downloads/file.php?id=25844
http://www.tesnexus.com/downloads/file.php?id=26196
http://www.tesnexus.com/downloads/file.php?id=18442
http://www.tesnexus.com/downloads/file.php?id=3409
http://www.tesnexus.com/downloads/file.php?id=21862(good for troubleshooting)
http://www.tesnexus.com/downloads/file.php?id=20736
http://www.tesnexus.com/downloads/file.php?id=20807
http://www.tesnexus.com/downloads/file.php?id=20371 (Needed for Integration)
http://www.tesnexus.com/downloads/file.php?id=22124 (Needed for Integration)
I'm mostly a quest mod player and I recently posted a big rundown for most of them that I've playedhttp://thenexusforums.com/index.php?s=&showtopic=157600&view=findpost&p=1349075 and http://www.gamefaqs.com/boards/genmessage.php?board=924363&topic=51137901.
Also: isn't it possible to delete your own topics provided no one has posted in them? Or am I thinking of a different forum? Defintely a different forum...
Edit: You did a pretty good job of describing what kind of mods you want,but if you want to get more specific here's my general reply to these:
List of lists:
http://www.gamesas.com/index.php?showtopic=1010109
Top 100
http://www.tesnexus.com/downloads/top/alltime.php
Files of the months:
http://www.tesnexus.com/downloads/filesofthemonth.php
Hall of fame:
http://planetelderscrolls.gamespy.com/View.php?view=oblivionmods.HOF
List of topics exactly like yours that have already been answered: (You can also find my favorites in post #4)
http://www.gamesas.com/index.php?/topic/1072579-the-any-mods-list-of-topics/
If you want any further help I suggest you tell us about yourself; what you like and what you're looking for... Here's some questions to get you started:
Have you played Oblivion already?
What sort of things interest you?
What type of Character do you usually play? (good/evil, theif/mage, roleplayer/random-no-story-hack-and-slasher?)
Are there specific types of mods you think would interest you? (Quests, graphic mods, gameplay mods, overhauls, etc.)
When did you leave?
What things bothered you in unmodded Oblivion?