Guys, shut the hell up about "you must not play many RPGs, fnar fnar" or "well, that's not really an RPG" or "you call that an RPG? This is an RPG" (Crocodile Dundee references optional). The Final Fantasy series are RPGs, just JRPGs, and there's no way to debate personal preference without sounding like a total jackass. Either put up real suggestions and be helpful, or just shut up. The self-congratulatory, snide, snarky, and presumptuously judgmental crap doesn't help anything. Badmouthing a game someone else liked doesn't make you sophisticated and worldly, it makes you a tool.
Rather than simply bemoan your choices of games (I liked FFX, personally), here are my suggestions. Though, bear in mind, it largely depends on why you loved FFX:
Shin Megami Tensei Persona 3 and 4. Well done games, combining dungeon-crawling exploration with RPG elements, and a stats/ability system which (while fairly intuitive) requires a good amount of customization. The stories are fantastic, and will actually make you feel for the characters. You'll like it for the depth and the characters, as well as the combat.
Super Mario RPG: An old one, but one of the best RPGs ever made. A Nintendo/Squaresoft collaboration which actually turns the Mario mythos into an exceptional RPG. Witty, charming, and fun. Think of it as a forerunner to the Paper Mario games, but... You know... Better.
FFXII: Okay, it plays a bit like an MMO, and that's not always fun. The draw of any epic tale of intrigue and world-altering adventures is still there, but it can feel a bit drawn out at times. Like FFX, you'll like it for the characters, but there's so little by way of actual character development, that you may feel like they just threw together a "greatest hits" of past characters and called it good. You'll like it for the characters (if you're able to live with a bit less of the cinematic feel of FFX), and you'll despise the combat.
Knights of the Old Republic 1 and 2: Fantastically done combat, immersive stories, and you actually feel like you're a freaking jedi. There's nothing more to say. Buy them. Right this second
Mass Effect: Epic space opera (in the best sense of the word). The combat is much more similar to Fallout 3 (for better or worse), but the story keeps humming right along (unlike Fallout or Oblivion), and there's a good balance between "I know where to go" and "there are awesome side missions" that you can both explore and not get bogged down.
Kingdom Hearts 1 and 2 (maybe Chain of Memories): vastly different combat system, more like God of War with RPG elements, but the story is good enough to keep you going. Look past the initial reaction that Disney makes everything bad, and it's sufficiently dramatic and funny to be really good.
Fire Emblem (all of them you can find): Turn-based strategy is always a bit of a leap for an RPG (Final Fantasy Tactics was so-so in many regards, and lost a bit when the story went nuts), but the Fire Emblem series pulls it off with grace. Every character is well-characterized, and has his or her own drawbacks. It's a pretty steep learning curve, but it's worth it to finish the final few levels with your full army intact. There's no real continuity between series (Fire Emblem 6 and 7 are self-contained, as are the two for the Gamecube and Wii), but each story is well-told, and really draws you in. The combat is simple to learn, difficult to master, and it takes a good amount of strategy and planning to win a lot of the time.
Fallout 3: Liam Neeson is about all I can recommend. I got waylaid around the second city, when I didn't know where to go, and didn't care enough to explore every nook and cranny. If you can access the story, I hear it's good, but getting on the train for that was more trouble than it was worth.
Oblivion: Same problem (though substitute Patrick Stewart for Liam Neeson). The game wants you to feel connected to your pseudo-avatar, but without clear direction and purpose, it's difficult to actually justify playing. Around the fifteen-hour-mark, when I'd done about sixty useless side quests, and achieved about nothing, I decided that a book was actually more immersive. It intends to give us an "I can do anything" feel, but that requires making us care about the person we're playing. Going from "here's your entire backstory, your complete motivation" to "whatever you want goes" feels a bit like putting down the video game and picking up some action figures. If I wanted to make my own story, I'd write a book, and not pay $60 for the pleasure.
But seriously, why has everyone forgotten about Morrowind just cause oblivions prettier? 
