Final Fantasy 8,9,10,12,13,14
I need to mention 13 again.
I likely need to mention 13 a third time (For graphics of course not overall quality).
Moment of mention here is the frozen lake.
Folklore. Wonderful charm, great colors, imaginative. Better graphics then Uncharted 2 IMO.
Mirror's Edge. Very nice style. Rare to see color used that well.
Valkyria. Chronicles. The pastel tones and pencil line aesthetic are just beautiful.
Bioshock 1/2. Rapture really is just great. Moment of mention though is Bioshock 2.
Mass Effect 2, specifically Lair of the Shadow Broker. You'll know it when you see it, look around and think "Ho...lee... fu-"
Wind Waker. I'm apparently in the minority here. Moment of note: Your first storm in the middle of the ocean.
Majora's Mask. Inside the moon, not necessarily graphically impressive, but artistically shocking.
Prince of Persia Sands of Time trilogy. And the Prince of Persia (reboot) even more then them.
Fatal Frame 3. The atmosphere here isn't all in the graphics but they are the foundation.
I can't think of more of the top of my head so sorry to everything I missed.
Edit: Needed to add it!
Minecraft. It's shocking how amazing some of the terrain can look.
I need to mention 13 again.
I likely need to mention 13 a third time (For graphics of course not overall quality).
Moment of mention here is the frozen lake.
Folklore. Wonderful charm, great colors, imaginative. Better graphics then Uncharted 2 IMO.
Mirror's Edge. Very nice style. Rare to see color used that well.
Valkyria. Chronicles. The pastel tones and pencil line aesthetic are just beautiful.
Bioshock 1/2. Rapture really is just great. Moment of mention though is Bioshock 2.
When you take control of the little sister and stumble around the heavenly environment awestruck with not only the art but it's implications about how the sisters perceive things.
On the Shadow Broker's ship, looking out to the storm around you with it's wrathful clouds and blinding light. It's as enthralling as it is terrifying a vortex.
Majora's Mask. Inside the moon, not necessarily graphically impressive, but artistically shocking.
Prince of Persia Sands of Time trilogy. And the Prince of Persia (reboot) even more then them.
Fatal Frame 3. The atmosphere here isn't all in the graphics but they are the foundation.
I can't think of more of the top of my head so sorry to everything I missed.
Edit: Needed to add it!
Minecraft. It's shocking how amazing some of the terrain can look.