Not counting games ported from other systems like RE2 and MM64.
-Gambare Goemon games. Rented the first one and was blown away. Liked it better then OoT in many ways. The 2nd was great too. My two favorite N64 titles.
-Almost anything by Rare: Goldeneye, Perfect Dark, Blast Corps, Jet Force Gemini, Diddy Kong Racing, Banjo Kazooie 1 and 2. Didn't like DK64, never played Conker.
-Mischief Makers: One of the first N64 games i'd ever played and still one of my favorites. Really fun and quirky 2D platformer.
-Penny Racers and Snowboard kids are (outside of DKR and MK64) the best racing games on the system.
-Doom 64 and Turok Rage Wars are (again outside of PD and Goldeneye) the best FPS on the system.
-Wrestlemania 2000, WCW vs NWO and WCW vs NOW Revenge. Back when we used to crowd around the TV and play well into the night. So much fun.
Out of Sega, Sony, Nintendo and Microsoft I think the N64 is the worst mainstream console ever produced. The N64 was the system I picked that gen and I was/am quite bitter that it got almost none of the great games the PSX and Saturn were getting at the time but I do have some great memories with the few games I did enjoy.