Skies of Arcadia (fav' RPG ever), Beyond Good & Evil (one of the best adventure game with the Zelda's), and Okami (too handsome, but a commercial kinda flop, so...)

Without a doubt...

Planescape Torment !!!

The hype behind that would be like Fallout. Hell I would be happy with a graphical remake.

1) BEYOND GOOD AND EVIL 2!

2) SECOND SIGHT 2!

3) ETERNAL DARKNESS 2!

4) OKAMI 2!

5) KID ICARUS 2!

6) RED STEEL 2! 

Even I have to agree that it's not really a CT sequel, but that by no means make it bad.  Judging it on its own merits, which is hard considering its predecessor, the game is well above average.  Maybe not fantastic, but certainly good enough to earn its own following.

Really, the "problem" with the game, as mentioned by many so called critics, is character development.  And, frankly, if you love playing RPGs that simply doesn't matter ('tis a shame I no longer have much time for this).  I think RPG stories are a shallow waste of time that get in the way of a book that will almost certainly be better in that aspect.  Character development in CT really isn't that great either, to an avid reader at least, and if you compare only the important characters of the two games then CC isn't even to be found lacking.

Though, obviously, what each of us desires from a game differs noticably.  I like to play the games I like for the fact that they play in a way I enjoy.  Almost everything else is nothing in comparison, though crappy graphics won't fly by me too easily.  Odd as it may seem, I genuinely enjoy the way a lot of RPGs play, including CC, and sometimes liked them for that reason.  CC may not have delivered the goods to you, good sir, but it delivered them to me without fail.

As they say:  "different strokes for different folks".  The game is, surely, not your cup of tea.  It is not, however, objectively a poor video game.  It is very well made, has a better soundtrack than even CT (though it's damn close), and has a pretty fun battle system considering how little character manipulation is really involved with the game (compared to some of my other favorites such as FF5, 7 and Tactics).

Double post... *sigh*

XIII

Beyond Good & Evil!

I would like to see a sequel to Freedom Force(PC), I know it had a sequel, but I enjoyed those games so much.

Hostile Waters 

Nexus: The Jupiter Incident

Evolva

Seconded.  I'm not really an RPG guy, but Chrono Trigger is a strong contender for my favorite game of all time.

Body Harvest on N64 desperately needs an updated sequel.