for movies, there's nothing quite like the intro to Up in terms of the feels. Everyone who has seen that movie knows exactly what I am talking about.
As for video games, well I'd go with the attempted suicide of Celes after she wakes up in what is essentially the apocalypse. After Cid passes...