Probably the best overtly so one was Castlevania Lord of Shadows.

Most of the time it doesn't work or works better when its in the subtext like Vampire The Masquerade Bloodlines