I can't agree.
It doesn't help that you start out by saying the system has no games after Mario 64 and Zelda titles. Heck, calling Banjo and Koozie a game that doesn't stand the test of time is laughable. Is it because Microsoft ripped apart Rare LTD and thus killed off the IP? Has nothing to do with the original quality of the first title. IT hasn't been remastered and rereleased over and over again because Microsoft hates money (as in, they absolutely should). It stands the test of time easily. Yooka-Laylee literally exists because of it.
But let's set aside that absolutely fantastic game and look at your complaints. Now, 2D games were obvious;y not prominent - this is an era when 3D console gaming became the new in thing to do. Can't fix your desire there. But no RPG games?
Paper Mario
Quest 64
Ogre Battle 64
Harvest Moon 64
Shadowgate 64
Not a huge list, but a pretty good list. JRPG's were all going to the PlayStation at this time.
But let's dive deeper into the no games claim.
- Goldeneye - literally popularized and paved the path for Halo/Call of Duty to do multiplayer. Not a Nintendo game, was exclusive to Nintendo's platform. Deserves to be up there with Mario 64 and Zelda for the genre it's in.
- Conker's Bad Fur Day - still holds up to this day, and did get full remastered on Xbox. Microsoft did what Microsoft did for all of Rare's IP and killed it off.
- Super Smash Bros - uh... does anything need to be said?
- Pokemon Stadium 1/2 - still today the best Pokemon games on home consoles, and it was great you could import Pokemon from your handheld games.
- Mario Kart 64 - didn't start on this platform, doesn't change the impact. Still by many considered to be the best in the series.
- Perfect Dark - the lesser of the FPS game mentions, but literally just as good for very different reasons.
- Star Fox 64 - still today, the defacto standard for the series. Most recent release literally "remade" this title. Also was ported to 3DS.
And the list goes on and on. Not nearly as extensive as the SNES, but much vaster than the GameCube. The GameCube didn't have any games that were near that same importance, and not in nearly the same abundance. IT has some good games, but N64 clearly has the better library overall.
Can't obviously talk about the visuals. They looked good at the time, but sure they had some muddyness. IT's all personal preference. That's why I talked about the games. When people basically reduce the library of N64 to 3 titles (two from one series), it really brings to light how inexperienced they myst have been growing up, because the N64 had a ton of hits.
It may not have had a lot of hits for say, a specific genre you want (JPRG), but then, the consoles that had that also didn't hit all the right chords with 3D Platformers, or party games, etc. Each console back then had it's ups and downs depending on what genre you like. It wasn't until more modern times when you could really look at a console and say "this has everything in abundance" - and much of that is thanks to the growth of the indie game scene.