From FF, FFX's ending and Rachel in FFVI really got to me.

In MGS4, the doctor euthanizing herself.

Not too many deaths have gotten through to me in games!