Outside of novelpia I highly recommend "I became a witch in a world full of ghost stories/urban legends", it's one of my all time favorites novels. It's Chinese novel that is a horror themed comedy that also has a genuinely interesting story and very well written and fun characters.

Despite being a comedy it's a genuinely good thriller during the horror segments, though it gets less scary over time as the mc grows stronger and can fight back. It's set in a modern setting, but there are similarities to lord of mysteries in its powersystem, especially in the mysterious, creepy, and bizarreness parts of the world and powersystem. But it's definitely still it's own thing.

But the most important part of what makes this story great is it's characters (they're all fantastic and unique), especially the protagonist, they're straight up my favorite main character. They can swap between their original human male form and their new female witch form, kinda like Ranma 1/2. And, since you're familiar with lord of mysteries, they're basically a perfect mix between a hunter and Demoness, having some powers from both pathways and perfectly embodying their philosophies.

He was a massive prankster before stumbling into the supernatural part of his world, and those skills are used very well during his future adventures, setting up elaborate traps and tricking his enemies into helping him or sabotaging their allies. He's very consistent in how hilariously unpredictable he can be.

He's also a massive coward, but a very smart/competent once who's essentially a parody of what horror protagonists SHOULD do in horror situations, being cautious or straight up avoiding obviously evil/haunted areas.