Several of those mentioned get to me, the end of ME1 when everyone think's Shepherd is dead. One obscure one is a small bit in Legend of Zelda a Link to the past. You meet someone in the Dark World I think it is, who has partially changed to a tree. He asks you to find his flute and when you do, he says to find an old man in the village and play for him one last time before he essentially dies. Gave me sniffles as a child.