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?
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.
Thats not entirely true, in fact its true in a perfect world where everything installs perfectly on your pc.
But in reality we know that if anything can go wrong, that it will, especially when you are dealing with Window's.
Now on the PC I have the tools to fix that problem where as a console doesnt have that option.
Now this doesnt mean that MOD's wont come to consoles, but there will in no way be the mod selection that PC users get to enjoy. I imagine the mods that will be available will be popular mods that dont involve improved textures, and they will have to go through extensive testing to make sure they dont conflict with anything and they will be paid for mods.