Aeris' death from FFVII obviously, most recently.. Joel's daughter from the Last of Us. :/
Hmm... Nope. Some did though. Got me close. Aya from Parasite Eve was one, umm Artyom from Metro 2033 was one... I can't remember much others that got me close.
Solid snake :')
Max Payne's was pretty bloody awful.