Speaking of FF, in FF7 the death of that one character (I know everybody has played it, but trying to keep this a bit spoiler free) was kind of tough. Actually, there were quite a few moments almost as powerful throughout the game. Most playable characters are tragic.

I DO recall weeping when Red howls to the moon, having discovered the truth about his 'cowardly' father, as a matter of fact.