Every N64 game I've beaten so far:

>God Tier
Castlevania
Castlevania - Legacy of Darkness
Goemon's Great Adventure
The World Is Not Enough
Duke Nukem 64
Ridger Racer 64

>High Tier
Beetle Adventure Racing
Duke Nukem - Zero Hour
Doom 64
Hexen 64 (probably the best way to play Hexen until sourceports)
Mystical Ninja Starring Goemon
Quake II
The Legend of Zelda - Ocarina of Time
Perfect Dark
Goldeneye

>Good Tier
Quake
Quest 64
Bomberman 64
Resident Evil 2 (worst version of RE2)
Super Smash Bros
Turok 2 - Seeds of Evil
Turok 3 - Shadow of Oblivion

>Low Tier
Daikatana
The Legend of Zelda - Majora's Mask

I also have a bunch on stuff on my to play list including Shadow of the Empire which looks just like my jam except every emu I've tried to run it so far on makes it lag. Indiana Jones and Shadow Gate 64 might be good too, as well as Jet Force Gemini, Sin & Punishment and Mischieft Makers (maybe) and Wave Race 64
I really don't give a shit about Mario 64 or SMK 64, every time I try them I ended up hating them. Not interested in the trendy so called "3D platformers" that don't involve any platforming at all but maybe one day I'll check out.