This thread is extremely stupid, not least because of (shock-horror-surprise) Crysis talk in the console forum about console games texturing with console RAM.
There are three options available for texturing :
1) Image textures, possibly multilayered, which will repeat but can be made to measure for the RAM available, and are fast.
2) Procedural textures, infinitely variable but very slow to produce in realtime without buffering, and if you're creating a texture on the fly, you're still limited to texture RAM availability.
3) Megatexturing, giving unique textures everywhere, but it's new tech and no-one's released anything using it yet.
So all games being compared here (on consoles. PC games are irrelevant here - you can always throw more VRAM at the problem with PCs - so please stop linking to PC pics and comparing them to console games...) are basically doing the same thing - using texture images.
So then you have
how the textures are used. There will be repetition. That's unavoidable, unless you have so few surfaces in RAM they can all be given a unique texture. In this respect we can compare titles based on number of textures present, streaming tech used to access more textures per territory, and application of textures to create the material look desired while trying to elliminate repetition.
The measure of success has to be how well the developers and artists manage to capture their look for their scenery without jarring limits like low-resolution textures or serious repetition. There are a number of titles respected for their texturing quality. Off the top of my head, GoW and Uncharted, and KZ2 is looking pretty fantastic. People have raised Bioshock as an example, and I'm sure there are more (console games. Not PC games. Just for those a bit slow on the uptake).
Gears was a landmark title, and it's texture fidelity has remained a high target. Comparing it to other titles, it has excellent resolution. However, it's repetition could be very apparent.
This pic shows cloned surfaces/objects. To Uncharted's credit, the application of textures has reduced the appearnace of the object and texture repetition so it's less noticeable. Yes, it's still there, it always will be with these very limited RAM amounts, shared with the rest of the game engine (and more complex engine will need to scale back textures to suit). But I think ND did an excellent job in balancing their texture budget to capture the feel and variety of surfaces. A quick spot of image Googling shows Bioshock isn't using texture blending as Uncharted does, and has plenty of surface and object cloning. MGS4 was a real hodgepodge, ranging was the divine to the ridiculous in texturing. LBP has greatfidelity but huge amounts of repetition to boot, with basically single texture bundles (diffuse, normal, etc.) per 'tile' repeated across the surface. Banjo Threeie has some great fidelity and diversification across the same, but the same clear repeating of tiles.
What console games are managing to create an impressive environment without notable repetition? Are there any that achieve incredible environmental scope and diversification?