Heartwarming: Castlevania: Lords of Shadow - Mirror of Fate
Dracula smiling and saying "Marie" when he looks into the Mirror of Fate after killing his son Trevor. Even as the unholy lord of darkness, Gabriel still remembers and loves his wife Marie.
Dracula, under the impression that he'd failed to save his son's life, personally gives him a tomb deep inside Castlevania.
The secret ending can get the heart stirring. Simon says farewell to his father as he stands on a hill, watching the castle crumble and Alucard fly off in bat form. After being orphaned and seeking revenge for so long, it seems that Simon is at at peace, having finally seen his father once again, despite how much he's changed.