Final Fantasy X was a big one for me. It was one of the first games I played for PS2 and was definitely the best looking game up to that point, I remember being in awe of how good it looked. God of War 3 was amazing as well, but I was expecting that more I think.

More recently, some of the Skylines in Destiny left me speechless, that game looks absolutely amazing.