Keep in mind that most of the games I'll mention aren't really straight up RPGs.
I strongly suggest upgrading to Fable: The Lost Chapters if you don't have it. It's basically Fable with an impressive Expansion on the end (new spells, new locations, more weapons, more quests). xD
Phantom Dust - It's an action-RPG and strategy game in one. It's hard to describe. To quote the game box (which in turn quotes Game Informer):
"At its core, Phantom Dust is like a card game, only ramped up with incredible graphics and explosive action."
I suggest looking up YouTube videos to see how the gameplay works. It's very active and fun. It's a beautiful game as well. But the reason why I love it so much is because of the unique and interesting story.
Demon Stone - An interesting action-RPG, very Tolkien-esque. Not amazing, but solid. More action than RPG, but still fantasy based.
Baldur's Gate: Dark Alliance - A fun action-RPG (hack and slash). Isometric view and all sorts of stereotypical D&D action. This one supports two players. A lot of the details for this game fail me as I no longer own the Xbox version and my sister borrowed my PS2 version. xD
D&D: Heroes - Similar to BG: Dark Alliance. Personally, I preferred Dark Alliance, but Heroes is interesting as well.
I would also hazard to suggest more action (even some adventure) games.
Things that stand out for me are:
Buffy: The Vampire Slayer (the original) - It's a great action game and carries the Buffy humor really well.
Dreamfall: The Longest Journey - An adventure game (with some minor, flawed action). Great story. And a ton of fun puzzles.
Psychonauts - Watch Yahtzee's review. You will learn everything you need to know about this awesome action/adventure/platformer.
EDIT: I completely forgot about a game I used to love to play called Enclave. It's a very strange action-RPG game, but is a lot of fun. I suggest finding out more reliable info through reviews and videos.
Another EDIT: Apparently Arx Fatalis is a true RPG that managed to do well. I haven't played it myself though. xD