The ending to Braid was a pretty neat twist on a conventional story. The "suicide" ending from Silent Hill 2 was one that got to me a bit too...