For me it was finding out that Angel really was dead in Wing Commander III, and that Hobbes was really a traitor. I was so mad about that, I refused to believe it for the longest time, even after I got to the final mission in the game I was still in denial.
EDIT: That probably ties with...