I've yet to find a game that makes me cry. However, there are some that give me some strong emotion, most notably the level "Retaking Red Square" in Call of Duty, when you and dozens of other soldiers rush headlong into a wall of German machine guns. The music and scene always give me goosebumps and makes me somewhat sad.