There are only two, and I mean TWO games you need for N64. Goldeneye and Perfect Dark. I played my ass off in both. Now I play it on my computer with a N64 USB controller.
In order to play Perfect Dark you need the expansion pack. Also get a memory card that goes into the controller.
Another great game was Command And Conquer. That was also out on PS I. I bought the link cable, made it longer and my Bro and I played in our separate rooms. We created so many tanks the damn game came down to a screeching halt. LOL Does the same thing on PC with Generals Zero Hour. Forget piss poor scripted AOD battles online. I used to use the map maker and made my own. Still got them to this day. You can play using this third party client.
https://cnc-online.net/en/
They made Perfect Dark for Xbox, but it was shit.
The sound track was so awesome in Perfect Dark I downloaded all of the songs. And with Goldeneye it follows the movie fairly well. Good luck getting the invincible cheat. I saw someone do it, but I could never get it. I think it's 2:15 in and out of the Facility level on Double Agent.
I cheated and added all of the cheats via the folders screen.
Favorite song.
"Stop where you are!" "I don't want any trouble."