Turn-based is for patient people who like to devise strategies. Real-time is mindless; a chimp could do it.
Buuuut, if you' re looking for good real-time RPG' s:
Baldurs Gate: Dark Alliance I, II (PS2, Xbox, GC) Either or, but the second one is better. These are absolutely fantastic, especially for two players. The graphics are very, very nice, the stories are so-so, and the gameplay is spectacular. It' s vintage hack ' n slash, but with the necessary RPG elements (i.e., upgrading weapons and armor, gaining experience and allocating earned points to increase stats and learn skills, etc.). The first one probably won' t take longer than 15 hours to beat, but the second could take about 20. The best part is that you can go back through it on higher difficulty levels with the same character, continually jacking him/her through the roof of all-supreme power.
Champions of Norrath (PS2) Deeper and closer to a real RPG than the BG: DA series, and awesome single-player mode. Much longer (about 40 hours), and with a real D&D style mixed with the realms of Everquest. It' s basically the same format as BG: DA, but like I said, closer to pure role-playing, rather than the virtual hybrid that the BG: DA games are.
Star Wars: Knights of the Old Republic (Xbox, PC) One of the best RPG' s of this generation, but it would help if you' re a Star Wars fan (which I' m not). This is real-time in the same way that Baldurs Gate on the PC is real-time. You can pause during battle and set weapons and skills, but the game is played out fully in real-time. There' s a great story here, and you can choose to play as either the Dark or Light side. It' s about a 30-35 hour RPG that has good replay capability.
Dark Cloud 2 (PS2) It' s one of the few real-time JRPG' s out there, and has a whole LOT of depth involved (more than any of the others listed here). In fact, the depth may be a bit too extreme for someone looking for something as simple as the Ys series. Many RPG fans swear by it. It' s real-time, hack ' n slash style in a dungeon crawler type of format, but with a really cool setting and story. Well over 50 hours of gameplay are here if you' re willing to dive in. Very intense weapon and item customization, creation, and upgrading.
The Elder Scrolls III: Morrowind (Xbox, PC) I would recommend this last, only because I don' t think it' s really what you' re looking for. Think MMORPG setting, only offline. Certainly real-time, but with a crapload of open-ended depth that can either be intensely boring or absorbing beyond comprehension, depending on what kind of gamer you are. Despite the fact that this game is good, I' m willing to bet that you might be intensely bored...but you never know. I figured I' d list it anyway.
I don' t believe that Tales of Symphonia for the GC will be real-time, although it may be a hybrid. Star Ocean 3, due out in August for the PS2, is most certainly a hybrid, just like Star Ocean 2 was (the battles are happening in real-time, but you can pause indefinitely to assign roles and responsibilities per character, as well as choosing abilities and skills, etc.)