Ok, this is what I think is gonna happen (might be totally wrong and I hope I will):
Most of the reviews will give the game 7/10-8.5/10 and the game will be considered as an "ok" to "great" game.
It won't stop the modders tho, more and more custom story will out and will keep the game alive for a while. After the big YouTubers will finish playing some of the custom stories, the big hype will be over and it'll remain as just a good horror game, but nothing special.
But you know what? It doesn't that matter what the reviews are saying. The thing that really matters that is all of your fans will love the game and will finish it with a big happy (and terrified) face
I'm sure everything will be fine