The most emotional game I played was To the Moon. It’s kind of like a jrpg walking simulator with some puzzles and light gameplay in it but a fantastic story.
The developer has made quite a few games in the series now but none hit quite as hard as the first in my opinion.