http://tes.multimediaxis.de/?go=dlfile&fileid=349. 80+ quests 60-100+ hour playtime, several great storylines, extremely fleshed out characters, unique and interesting quest/gameplay structure with choices and consequences, multiple solutions, skill checks, riddles, think-outside-the-box-situations, and much more.
Also:
Generic copy/pastes for these topics:
Spoiler
Lists and resources for finding many popular mods, and some good mods:
(note the distinction between the two, don't just follow mindless peer pressure, try and make your own opinions and find what you'll like)
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
General help in terms of installing, utilities, workshops, etc.:
http://tesivpositive.animolious.com/
http://www.oblivionmodwiki.com/index.php/Main_Page
http://tesalliance.org/forums/ (Check The Enclave forum, the Oblivion forum, or the Voice actor forum depending on your pursuits)
http://www.gamesas.com/index.php?/forum/87-iv-oblivion/ (Hardware/software for non mod related issues, Mods for mod users, Construction set for making mods.)
List of topics exactly like yours generic pleadings for "Any mods?" 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
The important parts being:
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
...
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.
...
Oblivion quest list
http://knol.google.com/k/toql-the-oblivion-quest-list
Recent quest mods that look good, but I haven't really been able to try (for the past year my computer access has been stunted a great degree):
Dark brotherhood renewed (I was able to try this one, it's pretty decent)
northern front
golden crest
Nehrim
Claudia's little Secret (I have played this one... it's one of the better, and slightly more believable "six quest mods")
Gweden Brothel (Theabove mod reminded me of this one, basically a business style mod where you recruit actual prosttutes for the vanilla location... I've played this one, it's decent.)
Adash - City of Magic
----------------------
-------------------------
I love how the things I actually write up for individual people slowly become generic copy/pastes themselves.
House mods there's http://oblivionsrealestate.com/ and a number of quest mods get you houses. In Integration you can earn like 3-4 player houses; I actually tried to submit it to ORE on their "Quest-Large" category, but they said it was too much of a quest. Funny thing is I would regularly see people asking for houses that they actually have to earn through epic, long, enthralling quests; and there was no way to really link them to the ORE site because the quest houses there are largely just buying it, or killing a few goblins to get it.
Bug fixes: There's the U patch as mentioned, other than that it's mostly isolated small stuff fixes, and game oversight type fixes like: http://www.tesnexus.com/downloads/file.php?id=25462 http://www.tesnexus.com/downloads/file.php?id=22894 http://www.tesnexus.com/downloads/file.php?id=5977, or http://www.tesnexus.com/downloads/file.php?id=19847.
Armor/weapon: Check the http://www.gamesas.com/index.php?/topic/1167983-list-integrated-items/
Monsters: MMM or Waalx