The most touching soundtracks.

Zia's theme from Bastion

I actually thought Zulf's theme from Bastion struck closer to home for me.
No spoilers, but the scene where you hear it is heartbreaking. And very fitting.

Baldur's Gate 2 has a really memorable sound track.

Also good: JPRGs

Lost Odyssey
Wild Arms.

Not exactly touching, but select themes from The Sims in its build mode are surprisingly rich. I really like Build 5 http://www.youtube.com/watch?v=F2MFv2xe8yQ (sorry, i don't know how to embed links into a word.)

Portal's Self Esteem Fund is also very emotional http://www.youtube.com/watch?v=pT7pVK5q8tk

hnng, Eleanor's Lullaby from Bioshock 2

for me is this great song from an awesome game!
World In Conflict
AudioSlave - Shadow On The Sun

also, this one, epic music imho
Max Payne

aww shoot man ti's the devil