Mods won't come to consoles because MS/Sony can't make money on them. Simple as that. Can you imagine the heads that would explode at those companies if Bethesda tried to convince them to pay to push out new free content that they won't see a dime off of instead of making another DLC? A new console generation is irrelevant to the answer, because the business policies will be the same.
Take a look at what MS and Sony do when a game comes out with new content through a patch or DLC: they advertise the new content heavily and try to get you to give them money. No attempt is made at bringing in new players.
Now take a look at what Valve does on Steam: they put the game on a discount (usually 50%+), often accompanied with a weekend of free play, and advertise BOTH the game and the new content to get new and old players involved again.
Which one of those business models do you think gels with the idea of distributing free content?
What kind of system access can consoles be given? PC users can fix bad files. Would that even be an option, getting into the OS and system files to fix the game when a mod breaks it?
Anyway, I'm not interested in mods. I have other ways to spend my time than installing and testing half a dozen files just so my water looks nicer or whatever. I can use the game as it stands, even if some things can be improved, and I'm not spending hours ****ing around with it.
You're apparently ignorant of how mods actually work. There is no futzing around with anything. Installing a mod consists of:
1) Going to www.skyrimnexus.com
2) Seeing a mod that's interesting.
3) Clicking the link to download it with the nexus downloader. The downloader installs it for you automatically.
4) You play the game.
It's easier to download a mod for Skyrim than it is to log in and post on these forums.