Banjo kazooie
DK64
CBFD
Rocket
Glover
Perfect dark
Zelda MM
Body harvest
Turok 2
TWINE
Winback
Mission impossible
Hybrid heaven
SF Rush
Top gear rally
World driver

Roadsters

Fighters destiny and its sequel are two fantastic extremely underrated fighters
Ogre battle 64 is one of the best SRpg of all time
Aydn chronicles is a complex and big WRpg thats worth it

I also played it but felt it had a lot of wasted potential.  It wasn't bad but it wasn't good either.   At times I felt I was playing it because it was practically the only RPG on the N64...aside from Quest64 but we will never mention that game ever again.

Anotehr fighting game I forgot to mention is Mace: The Dark Age.

Viper
true but still it was worth the time i spent on it
it brought something that was lacking in consoles, even if it wasnt top notch
Mace the dark age was a pretty decent fighter

Another fantastic massively overlooked Nintendo64 game is Battletanx 2

Duke nukem Zero hour and Quake 2 are two great shooters that were exclusive to the N64 (it got a completely new Quake 2 version that was way different from the PC/PSX versions, some say better ;)

-_-

...