The Gamecube had a fantastic library, had a very affordable price (post price drop GCN's were 99 bucks) and tended to outperform the PS2 on the multiplatform front. (see Simpsons Hit N Run or Sonic Heroes). Because of just how popular the PS2 was, the Gamecube got pretty overshadowed back in the day, and a lot of people remember it as an underwhelming console.
To back up my claims of it having a wealth of good games, let's rattle off some, shall we?
Metroid Prime, Animal Crossing, Fire Emblem: Path of Radiance, Tales of Symphonia, definitive port of Skies of Arcadia and many other Dreamcast titles, LOZ Wind Waker, Baten Kaitos, Super Smash Bros Melee, Soul Caliber, Resident Evil...er...yeah. I think that's enough.
SNES and Gamecube will always be consoles that I have deep nostalgia for. I have no fond memories of the N64 though. Sparse few good games that it had, it at least made breakthrough innovations to gaming itself. The Wii has a few gems throughout the shovelware pile, and I'll open up the good ol Dolphin emu to play some online stuff from time to time with friends, but for the most part, I think it's library was pretty forgettable.
Nintendo is always going to be a company that I'll have interest in, they've been a staple all the way from my childhood, to this very day. I'm excited for the NX, yet part of me is quite wary, given their choices with the Wii U.