Xenosaga and Legend of Dragoon were both good. I haven't played any FF later than #3 (I know, I'm a bit behind).

The most recent game that I like the music on is the new Prince of Persia: The Sands of Time.