The N64 mostly excelled at couch multiplayer games. Mario Kart, the Mario Party games, Super Smash Bros., Diddy Kong Racing, the wrestling games, Golden Eye... The console was mostly held up by Nintendo exclusives as third party support was poor and that explains why the console has one of the smallest libraries.
The N64 missed on the 3D revolution of companies pushing new boundaries. So no Squaresoft/Enix games when they were at the height of their creative powers, no Capcom with Resident Evil (except the second game) and no Konami with Metal Gear Solid and Silent Hill. There are many more series that were started or revolutionized on the PSX that don't exist on the N64 and it simply covered a lot more genres.