Bioshock 2 didn't make my cry but holy hell does the evil path make me feel bad. "You wouldn't ever hurt me, would you daddy?"
OT: FF7, FF9, and FF10. I'm sure there are more, but I'm really I giant pussy when it comes to that sort of thing. Books movies games, anything that is done well can...