Illusion of Time was also neat, we played that when staying at a friends house for a weekend.
There are some great suggestions here, but I have to second this one because it's a great game. Just all around well made, fun, good music, and a pretty good story. It appeals to the action/adventure and RPG crowd. Keep in mind depending on your region it could also be known as the Illusion of Gaia or Illusion of Time. I have played it many time and after getting rid of my old school games years ago, Illusion of Gaia was one of the first I bought when I started buying up old games a few years back.
And now I want to find my cart and fire up the ol' SNES.