here's all n64 games that are worth playing, for reference
-ANY Rare Game (Goldeneye 007, Jet Force Gemini, Banjo Kazooie, Perfect Dark, Banjo Tooie, Donkey Kong 64 and Conker's Bad Fur Day), except for DKR because I think it's boring. I don't know Killer Instict Gold either. Else you cannot really do anything wrong with Rare.
-Super Mario 64
-Super Smash Bros.
-Paper Mario
-Mario Party 1-3 (even though 1 is really bad compared to 2&3 I would actually recommend to start with it.)
-Ocarina of Time/Majora's Mask
-Turok (idk 2 & 3, the first one is a pretty solid FPS)
-Starfox 64
Stay Away from:
-Mario Kart 64 - Personal recommendation, it's a really bad game compared to newer installments.
-A Bug's Life
-Superman 64
Note: IDK about any pokemon games. I cannot recommend either Rayman 2 or Buck Bumble because I am against Ubisoft as a company, but at least Buck Bumble was a pretty good game.
Note2: I own the ps1 version of A bug's life, and it sucks a lot, but the n64 version is a lot worse, and probably the worst game on the console save for Superman 64.
Note3: Other N64 games I've played/I've seen a playthrough from:
-Pilotwings 64 (can't really recommend it)
-Quest 64 (seems to be about the only rpg on the console, only watched an AGDQ run and it looked kinda odd so idk)
-Sin & Punishment (forgot if this even came out outside of japan, looked interesting)
-Kirby 64 (okay for kirby fans i guess)
-Dr. Mario 64 (just wtf)
-Yoshi's Stpry (a really good game, but also really short)
-Tetrisphere, though i forgot about everything about that one.