Bare in mind that I wasn't suggesting that every single mod developed should be pushed through the system - just a few handpicked for cross-platform usage and such. If it was only a small (well, relative to the total amount), logging which mods are incompatible would not be too difficult, thus long as they're tested through beforehand. And also that websites like TESNexus would, of course, still exist - this concept would just bring a few extremely popular mods to the masses - many of whom who may not even know of the existence of mods. The way I see it, it could work better as a gateway to the modding scene than a replacement to it.
I take it when you say "the masses" you really mean the consoles, because the PC crowd is well aware where to get their mods.
And no, it wouldn't work as a "gateway to the modding scene".
I have said it many times before, and I will reiterate yet again, before script extenders, before mod management, there is a steep learning curve to the whole game modding concept, one curve that has taken us PC modders some time to learn. Sure changing a texture is simple, but no one is contempt with just changing textures anymore.
Just the simple act of testing a mod... To me, and I think most modders would agree with me, the most tedious part of making a mod, is testing it.... working on your texture, mesh, quest script, etc is one thing... but then you have to fire up the game, and test your mod, see how it works, what's failing, what doesn't look right. And depending how extensive your mod is, you have to do this 10, 20, 50, 100 times. Since a modder wouldn't be able to use any of the tools required for modding directly in the console, the modder would have to transfer the mod to the console and test it, every time the modder wants to test it. Now, this may not sound as much to you, but believe me, doing it directly in the computer is a PITA. I personally wouldn't bother trying to test my mod on a console.
Then you have the capabilities of a PC vis a vis the capabilities of a console, which can severely hinder the creative process of a mod. Mods such as high-res textures, or mods that spawn a large number of enemies, etc., I don't believe modders would tend to port those mods to the consoles because in order to do so, they would have to "cripple" their own mod to make it work on consoles, and not present it the way they want to present it.