are you talking rom or real actual game? http://www.romnation.net/srv/roms/26061/mame/WWF-WrestleFest-US.html
James Bond, Mario Cart 64, Perfect Dark, and Zelda were the main ones I played even though I never owned an N64.
Mario64's graphics are surprisingly good. Respectable even by todays standards. 007's multi-player shooter is epic. My cousins and I would play that hours upon hours during the summers.
Damn I wish I still had my N64. During my stoner phase I used to LOVE Zelda OOT. I could play that thing for like days on end. Still the greatest game ever as far as I'm concerned. I was the master of Goldeneye though. Used to start with like 1 bar of health and face 3 friends with full health. Disclaimer: pure untainted weed is not bad, but all things in moderation and there is a time and a place.