Then you probably want to get a PlayStation 2, and I can certainly recommend some good titles in a similar fashion.
First there are the 3 PSX/PS1 Final Fantasy titles 7-9. Final Fantasy 7 is a bit difficult to obtain these days, but you can find it on places like ebay, craigslist, and some used game stores. It's a good game, but I wouldn't pay more than $50 for it total. Final Fantasy 8 and 9 are quite easy to find on ebay last time I checked. A lot of people didn't like Final Fantasy 8, but I have to say it's probably my second favorite right behind Final Fantasy X. I thought it was a rather refreshing break from the usual Final Fantasy game. There are parts that just don't really make a lot of sense, but it's a video game, so you can't expect perfection. I also believe that Final Fantasy 8 was ranked in the top 10 for best video game love stories.
Final Fantasy X is still by far and away probably the best RPG I have ever played. That game had everything. Political intrigue, love, loss, religious intolerance, a big bad monster... More than that, the script authors and visual artists did a remarkable job creating an entire world. It's too bad the follow up game Final Fantasy X-2 was such a letdown in comparison. It might even be worth skipping if you love FFX as much as I did. X-2 will take almost everything that was good about FFX and squander it.
Final Fantasy 11 was an online MMORPG, so skip that one for the PS2. Final Fantasy 12 was good, but it just wasn't FFX.
Outside of the Final Fantasy franchise is Namco Bandai's Tales series. If you can read Japanese there are quite a few more titles you can enjoy, but the only ones that ever managed to be translated into english were Tales of Legendia and Tales of the Abyss. Legendia is pretty ho-hum IMO, but Abyss is excellent. Both games have a large number of optional sidequests for you to do, some of which can only be done on a second playthrough, so there's a large amount of replay value that way.
Something else to consider is the Shin Megami Tensei series, after you double check my spelling. I've only played Persona 3: FES so far, and I hope to get to Persona 4 when I get back from visiting family. Persona 3 was surprisingly good. The premise of a bunch of high school students who fight monsters by night and have to manage school and various social functions by day, sounds like a really dumb game, but it's surprisingly good.
Kingdom Hearts 1 & 2, along with the PS2 remake of the GBA Chain of Memories are worth looking into. The concept of mixing Final Fantasy and Disney characters sounds like a recipe for disaster, but it actually works somehow. My only complaint is that the actual plot for both of the main games is rather thin, and it's propped up by levels that rehash certain Disney movies like The Little Mermaid and Nightmare Before Christmas.
The Xenosaga trilogy was excellent. I especially liked the way they wove in a large chunk of Judeo-Christian mythology into the third game. Some people complained about the rather long cut scenes, but I didn't mind them so much since they were pretty interesting on the whole. And if you get wiped out by a boss, and there's a big long cut scene before the fight, you can skip through the cut scenes.
The Jak and Daxter series was pretty good, though it wasn't really an RPG series.
If you like a lot of mindless violence and killing demonic monsters, then you can't go too wrong with God of War 1 and 2, and Castlevania Lament of Innocence is pretty good if a bit short.
The Prince of Persia trilogy was also pretty good. X-Men Legends 1 and 2 aren't too bad if you're up for a good dungeon crawler. I'm not sure if Marvel Ultimate Alliance was released for the PS2 or not, but it's another game in the same fashion as X-Men Legends.
Some people like the Devil May Cry series, but they never really managed to keep my attention for that long.
If you like strategic RPGs, then Stella Deus is a good introductory title to get you ready for the absolutely fantastic time waster that is Disgaea. Disgaea has just insane amounts of replay value, and the story is full of humor. Much of it is rather juvenile, but it's still a good bit of lighthearted fun. You could easily spend hundreds of hours on that game doing different things. There are at least 4 endings I believe, and just a staggering amount of things you can spend huge amounts of time on.
Anyway, if you like RPGs then you can't beat the PS2 right now. It really was home to the RPG during the previous console generation. The GameCube did have the very noteworthy Tales of Symphonia, and of course the Xbox had Halo 1 and 2. The Xbox 360 has Tales of Vesperia, which was a solid title, but not terribly noteworthy. Eternal Sonata for both the 360 and PS3 was a pretty good game, and I'm holding out a lot of hope that Final Fantasy 13 will live up to the hype and be worth the wait.
But you can start with a relatively inexpensive PS2, and be able to play a lot of the old PSX and PS2 games which are pretty cheap now. Then once you get a better feel for what kind of games you like, you can decide whether you want to step up to a PS3 or move over to a 360.