What about Rogue Squadron? I always thought that game looked great.

Nothing will ever be able to beat this master piece

That was my first impulse, but I thought the left looked too good to be N64. Guess that in itself is telling.

WWE No Mercy. Still the best wrestling game I've played.

Conker's Bad Fur Day.

Conker's Bad Fur Day. It isn't even close. That game managed to achieve technical feats that even early 6th generation games weren't doing yet. The Killer Instinct team at Rare spent 5 years working on Conker's Bad Fur Day and it shows.

Although it isn't on the list, I think Turok 2: Seeds of Evil was the best realistic looking N64 game. The lighting in that game was spectacular as well. It looked as good as some of the best looking PC games at the time.

Perfect Dark

its aged but I'd still pick it

honorable mention maybe Rogue Squadron

Oh my God yes The hundreds of hours playing that with my high school friends. 

I am going to pick it up now because you jolted sheer happiness back into my memory. 

Such a great console. Wish the image clarity was better(doesn't even support RGB natively) but the games were so great.

Conker's Bad Fur Day & Turok 3.