Getting mods to work in Oblivion is quite an ordeal for your casual player.
I remember the first time I tried to get some mods up and going, it took me about 6 hours and I had to re-install oblivion and start over half way through.
I'm just saying that some sort of a streamlined mod experience would be nice, perhaps TESNEXUS and Bethesda could work together to implement a system... also might open the possibility for user generated content on the consoles.
Just got to say it... lol fail. Unzip, copy, paste, activate. That is how hard it is. That being said I know not everyone is computer adept, some of my friends can barely use Google. I hope there is some type of .omod like in the OBMM, where any new files like models and sounds are automatically packaged for easy moving and install.
I will say the kind of thing the OP is asking for though isn't easy on a game that you can mod to the degree you can change TES games. Look what happened if you were in the Frostcrag Spire and uninstalled that addon. Bam, Mace of Friggen Doom glitch. What if you have a mod that adds a character and as you are talking to them you turn it off? I would rather Bethesda specifically explain how to install mods on PC then try and do this.
And to the post I quoted, the whole user stuff on consoles is more an issue with Microsoft and Sony not wanting custom things on their consoles, not so much a technical limitation.