MGS, particularly MGS3. The finale was quite the twist, and truly amazing. It was the first and only time that I almost (almost, lol) cried during a game.
My other suggestions would've been Shadow of the Colossus, followed by the Legend of Zelda, but those seem to have already been covered. :P







