I wouldn't mind a PC to Console type connection, like a system similar to FIFA face stuff, create on PC export to 360, but perhaps more of a store option, Modders uploads mods into a program which checks if it is compatible, if yes then it uploads to the store and the console store updates and you can download the mod.. Perhaps you could manage load order in the same program as well and activate and deactivate mods.. So all in all, modding is PC only however mods can be multi-platform. But that being said, it would cost more into dev time and I'd prefer it spent on making the game, but won't happen.. Perhaps in the near future with Cloud sharing on the rise.
Oh and... Just for boredom I'll join in on this bandwagon here...
It is not going to happen! lol jk But yeah mostly like(If not certainly) not going to happen.
You skipped right past the most (technically) important aspect, there. "program which checks if it is compatible".
Compatible with what? All 10,000+ mods out there? And even then, you can't really automate that - any mod that changes anything is "incompatible" with the game because it overwrites records. A compatibility patch will be flagged as incompatible with both mods, because it overwrites their records. And that's not even getting *into* scripting - in order to properly decide if that was compatible you'd have to solve the halting problem, and that's a bit of a tall order just for video game mods.
It's just not a thing you can do programmatically, and the sheer volume of mods makes it not something you can do manually.
And of course, the relatively scarce resources available on a console are a set resource - developers know they can get right up to the border. You suddenly allow people to add more things in and you're going to find that you don't actually have the spare room for anything at all.