I have only cried three times while playing a FF game:

1.FFIX-
Spoiler:
When Vivi has supposedly 'stopped' at the end

I cried my eyes out

2.FFVII CC- I also cried when Zack died : (

3.FFX-Like many others,I cried at the end of FFX