If you didn't already own a GameCube you might now utilise the Wii's backwards compatibility. There really only are four GameCube RPG's available in the west, and three of them (Tales of Symphonia, Paper Mario 2 and Baten Kaitos) are really good. I would really recommend those besides what is already mentioned here.
Furthermore, the SNES classics Final Fantasy VI, Chrono Trigger and Secret of Mana are available on the Virtual Console for a low price.
Oh, and sorry for nitpicking: but Zelda games (except for part two) are not RPG's but fall within the Action/Adventure genre.