Well, in the future, Resident Evil 4 will be coming out for GC exclusively, so that is going to be awesome. Another banging looking Zelda game is coming out in 2005 too.

As for games for GC. As Robotic said, get Zelda: The Wind Waker, it is one of my favorite games I've played in a while. I haven't started Zelda: The Four Swords Adventures yet, but I've heard good things about it. Raziel swears upon Metroid Prime, but I couldn't get into it really, although I honestly didn't give it more than an hour of playing time.

Besides RPGs, there are other really fun games to play multiplayer, such as Super Smash Brothers Melee, Mario Golf, Mario Cart, etc. They are not to be forgotten. They pack a lot of fun. A lot.