I am always amazed by Banjo-Kazooie on the n64, and Super Mario 64. Modern games would be Halo and Bioshock, and while I don’t own a PS3, I have a high appreciation for Uncharted.
There was also a PSP game called Archer Maclean’s Mercury which blew my mind when it first came out.