Some other good soundtracks that haven't been mentioned:

The Legend of Zelda: A Link to the Past
Star Ocean 3 (the game was uneven at best but the soundtrack was frequently awesome)
Shadow Hearts

FFVI is definitely the best though.