Final fantasy 10 is the only one that really comes to mind at the moment though there was a lot of games I enjoyed the ending to this game made me ball my eyes out like a newborn infant. Really like the scenes, characters, and story. It is probably my favorite one since I stopped playing the FF series shortly after that one.
My choice goes to Ar Tonelico 2