Depends. The cosmic horror plot is mostly a bunch of clichés that end up going nowhere. The investigations can be fun, but they’re done better in the previous Sherlock Holmes games. I enjoyed exploring the town itself and soaking in the atmosphere, but there wasn’t enough there to support 20/30 hours of game.
If you haven’t tried those yet, I would recommend looking at Sunless Sea, World of Horror, maybe The Infectious Madness of Dr Dekker? I’m also invested in the Arkham Horror card game, which is very good but very expensive