Unreal Tournament 3 has served as a console gamer's diplomat, successfully pulling mods long restricted to PCs to the PS3 and *fingers crossed* the Xbox 360. But past mods have been in small pieces, like Samus skins, more meant to customise the game than fundamentally exploit its robust engine.
Now the user-based developers behind Tactical Ops (a classic UT mod similar to CounterStrike) are talking about bringing Tactical Ops 3 to consoles. While the team doesn't think that the first release of TO3 will support the PS3 or Xbox 360 (due to issues like button mapping), they're confident in the possibility for future releases. And when console mods become the size of full games, we can't stand behind a waist-height object fast enough.