Dark Souls 1 can be emotional with a strong and deep atmosphere but the narration is kind of loose.

Shenmue 1. Really special game focused on the feeling of losing a relative with emphasis on the story. Tons of bittersweetness in that game.

Resident Evil HD remaster has some very sad moment, even if overall it is more scary than sad.