Generic post for these topics. I can personalize my response to you if you answer the questions contained withen:
Spoiler
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
http://www.tesnexus.com/downloads/categories.php, http://www.tesnexus.com/downloads/tags/search.php, http://www.tesnexus.com/downloads/advancedsearch.php
http://tesivpositive.animolious.com/
List of topics exactly like yours that have already been answered:
http://www.gamesas.com/index.php?/topic/1072579-the-any-mods-list-of-topics/
Read the AZERessential topics to get the basic "get wryebash, OBMM, OBSE, start slow" basic advice for starters recommendations
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 did you not like about Oblivion? What did Oblivion not have or need more of?
Male or female character?
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
[b]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.
(Some of these are probably outdated by now)
http://www.gamesas.com/index.php?act=findpost&pid=15598757
http://www.gamesas.com/bgsforums/index.php?s=&showtopic=1073167&view=findpost&p=15603156
http://www.gamesas.com/bgsforums/index.php?s=&showtopic=1073167&view=findpost&p=15602927 (Don't really want a lot top 10's or simple lists but I'm desperate for cop/pastes at the moment)
http://www.gamesas.com/bgsforums/index.php?s=&showtopic=1075680&view=findpost&p=15650213
I would post more since you actually bothered to give some details about yourself, and what you're looking for, but I'm feeling pretty tired right now, and someone beat me to my usual Integration suggestion (80+ quests, 4-5 guilds, 24+ hours of silent dialogue, unique and interesting gameplay, etc.) lol.
EDIT: The surrendering mod is NPCs yield, and/or Vows and Covenants. The NPCs yield mod was originally made as like an add on to V&Cs surrendering mechanic, but since then V&C hasn't got many updates while NPCs yield has continued on, so NPCs yield has the formula down better, but Vows and covenants has some extended implementation into gameplay... I think you can still use both together.
Dark brotherhood stuff:
Better dark brotherhood sanctuary
Dark brotherhood renewed
Dark brotherhood continued
There's a number of mediocre short assassination quest mods that focus on extending the Brotherhood a little.
JQ's Assassin quest offers some unrelated assassination fun, and it's pretty high quality.
Dwemer:
Dwemer railroad
Dwemer sky ship (has a parachute/glider type thing too)