Either way, the outcome for me is the same: I did not enjoy the gameplay as much as for example, Dark Souls for me to return to the game at some point.
Though I admit the ecstatic replies from some people here got me actually interested in the genre itself.
I highly recommend trying out Cosmic Horror. I'd start with the Shadow of Innsmouth. It's what Bloodborne's DLC, The Old Hunters, draws heavy inspiration from in the last section.
Agreed with Azuren, give it a go at least but I disagree on where to start. Try A shadow our of time first as it's a perfect place to be intruduced without being overwhelmed. Also, stay away from internet theories as they are full of spoilers, obviously but they also put ideas in your head. A good cosmic horror story should stick with you for a few days afterward, picking at your brain to make sense of things yourself or to just reflect on the story. The world building usually happens in your daydreaming after the book for the most part, connecting the dots, type of deal.