For me it was in FF7 when Sephiroth comes down from above and impales Aeris with his sword. That really upset me for some reason. I think it was because I was really getting into the plot of the story and Cloud and Aeris were starting to make an emotional connection to one another.