I wonder how many other games have that kind of cult following solely because of supposed obscurity.
I know of at least one, possibly three. Only one is Nintendo though.
Gotcha Force. I owned that game when it was new. The premise is you're collecting toys and having them fight. It's a mediocre button mashing game that combines third person shooting with Pokemon.
It's also a rare collectors item, likely because no-one bought it back then. Yet I see it in retro collectors top GameCube games.
I used to hear about Misadventures of Tron Bonne all the time as one of the best PS1 games, but that was also rare and expensive. The PSN version got released for cheap, and improvements to PS1 emulation made it trivial to pirate. I don't hear about it now, though MegaMan fans sperg in other ways.
Metal Wolf Chaos. The crazy Japan only FromSoftware game that was the source of much hype and memes. The memes were old by the time it was re-released by Devolver. It felt like I was the only person to play that game. (I just checked, none of my friends actually bought the game despite having it wishlisted.)
I don't know if these count, but I'm guessing the King's Field and MechWarrior games will fall into this category if they ever get a re-release. I played them based on the recommendations from fans, it was amazing how quickly the fans changed their opinion in private from "they're all masterpieces" to "actually, all of them are a bit shit", with the only exceptions being the games that don't work on modern hardware. What a coincidence.