Henry's first meeting with Eileen in the hospital. She just barely survived her encounter with Walter, and waking up to see a man looming over her again frightens her so much that she starts crying hysterically until Henry calms her down. As bad as the eventual Escort Mission ends up playing out, that one moment was certainly enough to make players sympathize with her.
Despite the fact that he's been trying to kill you throughout half of the game, Walter's death is surprisingly sad. He's lying on the ground, reaching up towards the light at the roof of the dome you've been fighting in, whispering "Mom..." before finally dying. Just to hammer home the fact that all he really wanted was to be with his mother, his younger manifestation, who is still knocking at your apartment door, collapses and disappears. And then the door finally creaks open.
The "Eileen's Death" ending. Henry, master of Dull Surprise, sounds absolutely heartbroken...
The worst ending, where Henry fails to cleanse his apartment sufficiently, and Eileen ends up being sacrificed in the final battle. Killing Walter turns out to be a hollow victory, as Henry presumably loses his freewill to a deadly-to-his-physical-body headache and does not seem like he is himself after that event. A view of Henry's "unholy" apartment as it appeared at the beginning of the game is shown as a news report and is broadcasted on the radio, announcing the death of Eileen and the police finding Henry dead in his bedroom, severely disfigured. Getting this ending your first time playing the game, you might end up feeling very depressed.
Even adult Walter looks depressed.
The various cutscenes you can witness in the second apartment level which connect Eileen and Walter. If Eileen hasn't been attacked very much, she'll read Walter's history and sympathize with his plight, seeking to help him out of pity for what he's been through. If she's somewhat injured but not too badly, she can feel his presence in her mind and is absolutely heartbroken by the pain she empathically senses through their growing bond, until she's eventually driven to leave Henry in a trance. Finally, if she's fully possessed, she's plaintively whimpering for her "daddy and mommy", acting as young Walter's voice all while demonic tendrils swirl around her battered body, and she can only be snapped back to her senses for a couple seconds before returning to Walter's crying. It can honestly make you feel like such a dick for allowing her to be hurt that much.
The ultimate fate of most of Walter's victims, according to notes you find. Granted, several are not very nice people, but none did anything worth being damned to haunt his nightmare world. One can hope that defeating Walter freed them, but even that is... ambiguous.