Welcome to 2001. Unfortunately there weren't too many 'graphically detailed' games for the GC because a lot of 3rd party people bailed on it. I don't know where you're from, but perhaps you should have saved a little longer and gotten a Wii instead. You can still play all the old GC games, and there are already games on the Wii with realistic characters (though those games are not very good).

Try not to concern yourself so much with graphics, and focus on enjoying the games you play--if they are any good anyway. Resident Evil games weren't so hot, gameplay/fun-wise before 4. Since you have a gamecube now, get Resident Evil 4.