> A good story should work even if you know what will happen.
Agreed. My first play-through of Dark Souls was thoroughly spoilerified, because I was consulting a walkthrough and reading a little bit ahead of my current progress, from start to finish. And you know what? It was still a phenomenal experience.
In fact, the experience was enhanced somewhat by knowing what was coming ahead. I could look forward to facing a boss like the Four Kings, having already read some of the lore and knowing it would be a brutal encounter.
Later in the series, my first play-throughs of Bloodborne and Dark Souls 3 were blind and unspoiled, but I don't think the experience was gigantically better for it. Some reveals were pretty cool [1], but I don't think I would have suffered to have known about them in advance. In fact, I still thoroughly enjoy all of those games, despite knowing them inside out and back-to-front.
[1] I'm thinking specifically of the transition from The Consumed Kings Garden to Untended Graves in DS3. Probably better unspoiled.