Oblivion's side quests are good but the world could use more. Kvatch Rebuilt lets you actually rebuild the destroyed city, Elsweyr adds a whole new province, and Mannimarco Revisited fixes the disappointing necromancer faction. These add the content the base game teased but never delivered.
Ranked by hand, not auto-generated. Every mod links to its full page with install guide + compatibility.