I think Carmilla was the most obscure horror character ever to become a Castlevania boss, at least in the early games that I've actually played.
My Hawthorne pick would definitely have been Young Goodman Brown. I haven't read the first four stories that you listed.
> and they're by and large not horror
Well what gets counted as horror in literature is generally alot broader than in film.