A well-executed and shocking plot twist is hard to forget. And there have been many of them in video games over the years.