Paper Mario and Hybrid Heaven are pretty much the only two good RPGs on the N64 as far as I'm aware. Oh, and Ogre Battle 64 was apparently good but I haven't played it yet (downloaded it on the Wii shop a while ago, though).
There were a few others (Holy Magic Century, Aidyn Chronicles) that were supposedly big disappointments.