If this turns me on, does that make me a bit of a necrophile?

Not at all.

Loving the dead != loving the personification of Death.

Vampires, on the other hand, are something of a grey area.