The theme of this unique motel will give many people anxiety, and its location next to a graveyard popular with ghost hunters doesn't help. But if you love the kitsch and scary, it could be a night to remember