All the really good games were already listed, the other ones I could think of all come on the PSX except the wrestling games.
-Nightmare Creatures
-Mega Man 64
-Forsaken
-Southpark
-WWF No Mercy
-WWF Wrestlemania 2000
-WCW Revenge
Also, already listed, but I'd like to Ogre Battle 64, Jet Force Gemini, Goldeneye, Perfect Dark, Castlevania, and Castlevania Legacy of Darkness are some of my favorite N64 games(there's not that many I actually like for the system :P.)
How you noted Castlevania on 64, it's either a love it or hate it, which I can't really understand as you have all these people that love the terrible, extremely small staged, collectathon game like Mario 64, and the only problem with CV64 is the camera(just like Mario 64.) Anyways. The CV64 camera is worlds better than the awful Mario 64 camera, though it's still not too great. The game has huge stages, lots of good bosses, quite a bit of platforming that actually works well for how the camera controls. I love both CV64 and CVLoD as they're altogether great games.