User-created mods stand a very good chance of changing console gaming. This particular industry is seeing extreme competition. It is time for developers to think outside the box and look for new ways to differentiate themselves among the hundreds upon thousands of competitors. Such advanced thinking can only be good for the consumer.
A created modification to a console game literally changes the gaming itself. Thus, the answer would be a definitive "Yes". The ability for a person to enhance and manipulate a game for their own personal enjoyment can add multiple layers and dimensions to a game, adding diversification and even more personal experience within a realm that formerly was just as it was.
The days of going to the game store and purchasing game content directly from its makers are over. With the ability of gamer's themselves to create content within games, they now have the power to affect what consumers play and download. Those who have dreamed of creating their own video games have had their dreams fulfilled.
The gaming industry is constantly changing and is always in a state of flux. User-Created mods will only serve to enhance the gaming experience and may help to develop future gamers which is a win-win for the entire industry. Entice consumers now and then cultivate future programmers and developers. Sounds like a plan!