well theres no real scene thats more emotional:

seeing clouds life made him seem pathetic in ff7 and that kinda made you feel sorry for him, then theres aeris (or aerith but i prefer aeris) when she dies by sephiroth

Then theres the relationship between the boss and snake which highlights some real tearjerking action to some people

Theres also the end of ff10 where yuna cant even properly hold tidas

There are other games but its too late to think of them