Thought I'd add my two cents here. I think it's funny that so many folks see no chance of this happening and saying Microsoft and Sony would be so against this idea. Sure, there are going to be hoops to jump through that don't exist for PC modders, but there's already a precedent for user developed content on consoles, the groundwork started back when the 360 and PS3 released; all the parties involved likely just need to agree on the hoops. Mods keep a game running years past its prime, that's something they can all take to the bank and that means it's going to happen sooner or later.
For example, back in 2006, Microsoft announced they were establishing the Creator's Club, a club for folks who (for a paid membership hoop) would have the development tools needed to bring user developed content to the XBox 360. From Microsoft Rep in 2006:
"By unlocking retail Xbox 360 consoles for community-created games, we are ushering in a new era of cross-platform games based on the XNA platform. We are looking forward to the day when all the resulting talent-sharing and creativity transforms into a thriving community of user-created games on Xbox 360."
http://msdn.microsoft.com/en-us/library/bb976089.aspx
http://create.msdn.com/en-US/
Likewise, in 2007 Sony took their first tentative steps into user content with Epic Games to get the user made content made on the Unreal Editor piped to the PS3. Epic Games VP was quoted in 2007 discussing user content for T3:
When they embrace user-created content, that's what it means to be an open system. That's why we're on PlayStation 3 first—because they are embracing user-created content. It's not just moving the deck chairs around the boat. They are embracing real art
http://www.psxextreme.com/ps3-news/2238.html
To date, no, there is no perfect user content share system for consoles and I'm not saying that (don't misquote me troll, I see you over there), but user made content on consoles is coming, no debate really. Mods take a game with a one year shelf life and give it six, Six years of new players wanting to buy the game just for the extra content and we all know there's no end to console gamers asking for mods. In the end, it may cost modders dearly to get their content on a console, signing content agreements, paying memberships fees, toeing the line as it were, but maybe this means in the future, we'll also see some small financial kickback for our independent development like iPhone App devs. If Todd Howard says it's on the table at least, that should mean something in of itself. :foodndrink: