GoldenEye 007 is my favorite video game of all time, so of course this gets my vote and for me... it's not even contest.
Just like with the Ocarina of Time, I had more fun watching my little cousin played Mario64, than actually playing it myself. In my opinion, it just wasn't nearly as fun as the original three Mario games for the regular Nintendo. Sure, the graphics were better and all that, but I was bored playing it.
GoldenEye 007 was also a game my cousin had. I remember the first time I watched him play that shit and just being blown away by it (I thought it was going to suck because I've always hated Bond movies, and do to this day). As soon as I got home, I made sure to let my mom that I wanted a Nintendo64 for Christmas and GoldenEye 007 to go with it, even though just a few months earlier she got me a Playstation and I had ZERO interest in ever getting a N64. But after playing GoldenEye 007, I had to have that game. Never did I want something as bad as I wanted for that. And my mom, being the awesome lady she is, granted my wish and got it for me for Christmas. Even playing it a 1,000 times at my cousin's house before that Christmas morning, when I hooked up that Nintendo64 and popped in GoldenEye 007, I was blown away by it like if it was first time playing it. And I never, ever got sick of it. Never.