I can't seem to find too many more rpg's on Gamecube, 'side from like... the Zelda and Tales series'... was Pikmin an rpg? Meh... anyway, it's mostly all sports and 4 player games. And some action adventure type of deals... and then there are games like, as you said, Resident Evil and then games like the Clash of Ninja series, which... whether being a Naruto fan or not, can get pretty interesting and actually really fun to play when you're with 2 or 3 other people.
That's just scratching the surface...
But my opinion doesn't matter much. All we have down in Australia are X-box and it's Halo games. Everything else is an online order, mate.