Never crying because of a game, but the most borderline moment was in Legend of Mana, at the end of the Jumi arc.