The part at the end of earthbound. I was playing it without a guide back when, losing to the final boss, and in a panic I selected the girl's "pray" move. Throughout the game that move has a small chance to heal you or debuff the enemies. But in the final fight instead it pops up

"{Girl} prayed from the bottom of her heart! "Please give us strength..... If it is possible.... Please. ...Somebody help us."

And then it cuts to the first character's mother in her kitchen, and has some dialogue of her worrying about him. Each subsequent prayer cuts to other characters that you met throughout the game.

Mind completely blown as a child when this happened.

I don't know the name of this trope but it gets me teared up every time.