Yeah, but everything you just said can also be applied to the Wii U. This description basically paints the N64 as a niche console with some very vocal fans. If that is your assertion, then I can agree with that. N64 is a lot like the Dreamcast or the Wii U.
I would argue that the N64 has had much more of an impact than the Wii U ever will. At least on the software front. We got genre defining games with Super Mario 64 and Ocarina of Time. Without those games who knows how 3D Mario and Zelda would be today. That's not to mention that it started the Mario Party, Paper Mario, Banjo Kazooie and countless other game series regarded as classics. So I'd refrain from calling the N64 "niche". At least for me, it's impacts are still seen.