It’s top tier, like almost masterpiece shit like 60% of the time, low-key falls off at the end, doesn’t get better after the house section. It’s never bad or boring but the end section especially just ain’t as good as the rest of the game. The level design falls off so hard it’s crazy and the enemy variety is quite thin, it stops being scary too cuz you learn exactly how to deal with everything pretty quickly and by the end you have so much ammo and weaponry that nothing can stop you anyways. It’s really not a hard game either, i died 4 times in my playthrough with 4 steroids used.
That being said i definitely don’t regret playing it, the atmosphere early game especially is really effective and although i didn’t find it all that challenging, the encounters with the family members were tense and engaging. The most enjoyable parts of the game for me are when ur set free in the house and just left to explore at ur own leisure. The level of detail in the game at times was reminiscent of an immersive sim, very impressive stuff. The problems just get really egregious when you leave the house and go to the ship wreckage, everything past that point is kinda mid.