There's no way I'm going to list every game that has wowed me in the 20 years, that I've played video games, so here's just a couple of the most breath-taking ones:
Super Metroid, Metroid Prime, Shadow of the Colossus, Super Mario Bros. 3, Ocarina of Time, The Wind Waker, Chrono Trigger, Resident Evil 4, Bioshock & God of War III.