I'm a bit offended that nobody has suggested Valkyrie Profile.
Not really surprised though, the game has had a limited American release and has never been released in the PAL regions. Probably one of the best RPGs I've played, the only problems are that it's not very obvious what you have to do and thatsome most weapons have a chance of breaking which makes powerful weapons too awesome to use(Finagle's Law [http://tvtropes.org/pmwiki/pmwiki.php/Main/Ptitlee6pckmje?from=Main.FinaglesLaw] will make that "Sword of Dragonslaying" break right before that huge dragon or on the first hit if you saved it).
Not really surprised though, the game has had a limited American release and has never been released in the PAL regions. Probably one of the best RPGs I've played, the only problems are that it's not very obvious what you have to do and that