There's been a few moments, a couple teary eyed parts in Final Fantasy 7. Secret of Evermore had me equally laughing and choked up, no tears though.
Last actual tears running down the face moments i can remember in a game as an adult was when SC2 was released.
https://www.youtube.com/watch?v=LOjDr6Xgk7s
Literally me saving the love of my life, tears in my eyes.
https://www.youtube.com/watch?v=RojwUgEV3ug
Was good learning that the love of my life was still fighting for me.
https://www.youtube.com/watch?v=yRwOkXUdlog
"Do you still believe in me" was a teary eyed moment, shouting at my TV "DON'T DO IT LITERALLY ME!"
https://www.youtube.com/watch?v=kScAk4L7Y3Q
Tears down my fucking face every time.
"Thank you anon, for everything"
"My pleasure milady, always was..."