I'm going with one of all the time greats... MGS 1, when McDonnell Miller reveals his true identity, Liquid Snake!
I remember seeing that for the first time and thinking, OH SHIT!! MIND BLOWN!!
Are there plot twists better than this, SW? What are the biggest plot twists in gaming?