I knew somebody was going to say "Sephiroth murdering Aeris" within the first three posts. Am I alone in this, or was it totally obvious that it was going to happen? I saw it coming a mile away.
My most shocking moment would have to be the end of Soul Reaver 2.
SPOILERS
The final battle between Raziel and himself as the leader of the Sarafan just completely came out of left field. I was completely dumbfounded when I came to the realization that Raziel killed himself as a human almost a millennium before his reincarnation as a vampire. So badass.