Your list isn't bad, and you bring up some points, but I'll have to counter:
Mario Sunshine deserves to be a mario game about as much as Mario 2 did. It was the sad token mario game that followed Mario 64, and was waiting to grow up to Mario universe.
Zelda windwalker: again a valley of talent, where as the 64 gave us ocarana of time (awesome game) and majoras mask (good enough), this was a dismal failure in the long line of zelda greatness. At least Twilight princess was much better.
Skies of Arcadia: Ported to the gamecube from the dreamcast.
PSO: Once again, ported from the dreamcast.
Viewtiful Joe: this guy made it to the PS2, a better, backwards compatable system
There is no doubt that smash brothers and metroid were the high points for the system. Personally, I would place Tales of Symphonia as a reason to get the system. I loathe that japan got a ToS release for the ps2.
However, on that note, once again nintendo failed to get good third party support, especially in the RPG department. The ps1 and ps2 DOMINATED the rpg department for their entire lifetimes. N64 and gamecube did nothing to encourage quantity or quality coming out. They abandoned quality rpg's on these systems entirely and released rpg's on handheld systems.
Do I hate the gamecube? no, I hate nintendo for failing me during the N64 era, and not fixing it's flaws in the gamecube era, and I continue to hate them for making the Wii even less appealing. For a company who had it all figured out during the NES/SNES era, they have had to market their systems almost entirely by their first party releases. Backwards compatability and built in cd/dvd player helped rocket the sales of sony and microsoft past them.
Also that generation had a weird price coincidence where all three systems were going for roughly the same price. Compared to today where the ps3 is horribly overpriced, the Wii is practically a steal and the Xbox 360 is comfortably in the middle, we see the effects of the declining economy on choice of video game systems. Wii gets bought more by parents because it's cheaper. Xbox gets bought more by gamers with their own income because it has the best selection of games. Level the playing field by making price reletively the same and you get alot of hate for the gamecube because the ps2 and xbox had so many more good exclusive games. I might have bought the gamecube for a game like KotOR or Morrowind, but nintendo probably would have butchered them.