Not exactly an in-game death (or death at all), but Red XIII's Dad is the only one that gets to me every time.

I was happy when Aeris died. She had it comin'.