Plot Twists in Video Games: Out with a Bang or a Whimper?

What makes a good twist ending to a game? Why are some twist endings so reviled and constantly made fun of? I examine what makes a twist ending...