Mario 64, Final Fantasy 7, Super Mario RPG, Yoshi's Island
Other games that were awingly mind blowing:
Dark Souls Demon's Souls Metroid Prime Super Metroid Super Mario Bros 3 Zelda Twilight Princess Zelda Link's Awakening Donkey Kong Country 2 --- http://i1306.photobucket.com/albums/s574/akxsion/Nintendo.png http://i1306.photobucket.com/albums/s574/akxsion/SMRPG.jpg
Although I do agree completely 100% with the TC, it wasn't just SM64 that was mind blowing, it was pretty much all 3D games at the time. I remember being floored by what the Sega Saturn and the PlayStation (1) could do. Seeing Daytona USA run on my TV for the first time was amazing, and it didn't stop there. Every different game was a new wonderful experience when 3D gaming was new. I remember loving Panzer Dragoon, D, Ridge Racer, Air Combat and so on just for the 3D graphics alone.
The N64 was no different and I think this feeling pretty much ran through that generation. From 1995 through 1998 I think games were very very exciting all around. It was a very fun time to be a gamer. --- My good movie of the week: "Coraline" Game of the month: Heavy Rain (PS3)
These two games are still to this day the only games that give me that feeling.
Games that have come close? I love RTS...Warcraft III: The Frozen Throne was mind-blowing for me at the time, even though I think Starcraft is the better game overall. --- I'm not man enough...to be human.