Yes.Good morning blues said:The best for me was Knights of the Old Republic (the revelation regarding your past). I didn't see it coming at all, and yet it didn't feel out of place.
Bioshock's twist was also pretty good. Certainly wouldn't have expected that if I hadn't heard about it before playing. But mentioning that game brings back memories of System Shock 2.
The woman who's been helping you throughout the first half of the game actually committed suicide, and the person talking to you was actually Shodan. Woah.
Also - obligatory mention of Aeris' death. Surprised that I'm the first to mention it.