IGN just posted this neat video for Metal Gear Solid 4 comparing scene from the reveal trailers to scenes as they appear in the final game.
Overall I say the final product is much better, though the lighting of the graveyard in the final version leaves a little bit to be desired when compared to the E3 trailer. Also, anyone else notice that the box that watermelons are in say "No Place For Hideo"? , i found that a little amusing.
The removal of yellowy tones in favor of that much more detail gray tone reminds me heavily of Zelda: Twilight Princess. Because in that game, the Twilight was initial a black and while zone that lack any sort of feel, where as the final product gave us a hazy dray, translucent world that was much more worth of the name Twilight.