Eyes on Me is probably the only one to have a real emotional impact on me, but that was due to the scenes unfolding on the screen as it was playing.

Apart from that, there are so many great FF tunes, but right now I like Eternity from FFX-2