Chrizum on 01 March 2012
Terranigma's ending was pretty great. That game had an amazing story, especially considering it's a SNES game.
Silent Hill: Shattered Memories' ending shocked me as well, although there are multiple endings and I have only seen one.