It’s horror in the sense that Bioshock was horror, but much less so. There are some areas with ‘tension’ that you pretty quickly become accustomed to, just as you would in a game where there is a ‘progression’ of areas where each area you move into is quite difficult at first until you get the resources and build the new items from that area.
I love survival/building games, and so do most of my friends. Even the terrible ones are usually fun. So I’d posit that it’s the opposite with a caveat: liking one for more than its story means you’ll enjoy the others.
I think it’s more indicative of games/hobbies as a whole than the survival genre specifically. People who love the adrenaline of a motorcycle may not enjoy the thrill of going down a mile high mountain on two thin sticks, IF it was the rumble of the engine beneath them that they actually enjoyed. If it was the rush of the speed though (or in the case of survival/building games, the exploration and struggle to stay alive and not lose your stuff), then they’ll likely enjoy the other adrenaline sports.