>I dont find his writings very scary but fantastical and macabre!
This is similar to what I’d say to the OP about Lovecraft. “Horror” in literature can be harder to do in such a visceral, unsettling way as in cinema, except perhaps with gruesome unsettling depictions of torture, murder, etc. (which can be the same level of schlockiness and cheapness as jump scares and gore are in cinema). Lovecraft isn’t really going to “scare” you so much, assuming you’re a reasonably sane adult, it’s more like a sense of wonder, the fantastic, the eerie, the unsettling, the magical, the wondrous, the grim, macabre, etc. It’s more like the atmosphere and suspense that you read it for.
However, one book I found genuinely terrifying when I first read it was Whitley Strieber’s “Communion.” Funnily enough, this is reputedly nonfiction according to Strieber, and he’s maintained this staunchly for decades, although he did have a career as a horror writer for many years before coming out with it. It’s one of those rare books that had me scared in broad daylight, although I was an impressionable teenager (16-17) when I first read it.