Thers sooo many. (halo2 live,Zelda,Goldeneye,phoenix,Goof troop, manymany more)
But one that really sticks out is Metroid Prime
Coming to the planet and going to the Artifact building. I remember looking upp at it's beauty. Rain splashing on my visor. I actually cried a tear of joy.
It was the best looking game I had played at that time.