Surprised no-one's mentioned Crisis Core yet. That was an incredibly sad ending, in spite of the fact that if you're playing it, you'll have played VII and know what's going to happen.
Even though I was crying like a girl by the end, it was extremely well done. Damn you Square, for toying with my emotions like that...