*cough*MMM*cough*
*cough*OOO*cough*
*cough*Frostcrag Reborn*cough*
*more cough*Natural Environments*more cough*
*tweaked cough*Unofficial Patch*tweaked cough*
Shall i cough on
*cough*OOO*cough*
*cough*Frostcrag Reborn*cough*
*more cough*Natural Environments*more cough*
*tweaked cough*Unofficial Patch*tweaked cough*
Shall i cough on
*cough* Living Economy *cough*
*cough* Illumination Within *cough*
*cough* Daggerfall/Morrowind Books *cough*
*cough* Book Jackets *cough*
*cough* Screen Effects *cough*
*cough* Alternate Start *cough*
*cough* Cyrodiil Transportation Network *cough*
*cough* Kyoma's Journal Mod *cough*
*cough* Elsweyr, the Deserts of Anequina *cough*
Mods are what make Oblivion playable for me. True, many of them are fixes, but I don't think they can be classified as "minor" fixes when those fixes completely change how the game plays and sustains its value. And quite a lot of the real content mods out there are intended to have unique moods and explore a different feel than what Bethesda was going for, there are also a lot (such as the Elsweyr beta) that stick stringently to lore, stick stringently to the feel and style of game Bethesda sought to make, and make the whole thing worthwhile.
Besides, even if some mods don't fit a user's preferred tastes, that's the great thing about the modding community: It's almost infinitesimal in scope, so a user can easily find other mods that are more to their style. Or they can request or suggest a mod they'd like to see, and an inspired modder can take them up on it. Or they can pick up the CS and make it themselves, true to their own conception.