From what I've played, it's unquestionably the ending of Professor Layton and the Lost Future. Up until that point, the series had some very interesting plots, but nothing that I would call terribly emotional. But that ending, oh dear god that ending - I felt like I had been punched right in the face from nowhere.
I am literally tearing up right now just to recall it... I am such a goddamn sap!