Wander .... in Shadow of the Colossus
Tidus at the end of Final fantasy X.... and the music just wants you to shed a tear
Tellah .... in Final Fantasy 4
Lots of character who dies in Dragon Quest 8
The introduction in Xenogears
Sarah dying in Castlevania Lament of Innocence

...there are a lot more, but I'll stop