Hmm, just gonna list some off the top of my head that I've enjoyed.
Xenogears - Playstation 1
Chrono Trigger - SNES / Playstation 1
Chrono Cross - Playstation 1
Legend of Dragoon - Playstation 1
Final Fantasy VI - SNES / Playstation 1
Grandia series - Playstation 1-2
Vagrant Story - Playstation 1
Star Ocean series - Playstation 1, 2, 3 / Xbox 360