The only other time I nearly cried at a video game was when I was playing Mystic Quest on the Game Boy (before it was re-released under the name Final Fantasy Adventure - the same game that was re-made for the GBA and called Sword of Mana!)
(SPOILER)Amanda sacrificed herself to save her brother Lester after being bitten by Medusa...