There were a handful of great gamecube games, mario kart dd, re4, windwaker, donkey konga, but it seems like the gamecube really struggled from a lack of 3rd party support. Best was probably the DS, then snes, then gba, then NES, then wii, then gamecube.
The worst of the nintendo systems are probably
n64, gbc, wii u.
The way the switch is going, it may end up being the best of all, but it's a bit early