Two things immediately come to mind.
In terms of games, I'd have to say Unreal 2. I played it when I was much younger, and the ending, more specifically the final "goodbye" made me tear up. I've despised the word goodbye ever since...
In terms of books, I'd have to say The Lovely Bones. I...