I'd throw a vote towards Bioshock and Would you kindly. That's probably the most recent, widespread "mind blown" twist that I can think of.