The N64 is the only console that can both rank high in best consoles of all time and also get some mention in worst consoles lists because of its sales (and baffling cartridge choice of media which is what led to the low sales and all of its troubles in first place). The N64 was the power House of its time and delivered games that weren't possible on the competition based on pure processing power and Nintendo's game design genius. That said the GC sold far worse and to me was a worse console.
It's because the N64 was home to monumental games as well as the most monumental F-up in video game history.
It's kind of like the SMD, a relatively average console when you examine everyone's place in history. At worst it's the best of the worst, and at best it's the worst of the best.
I describe myself as a little dose of toxic masculinity.