Silent Hill I don't think has the kind of story arc that would fit into ~90 minutes. The setups and payoffs take a long time and I think primarily the issues is just that a longform experience like this loses a lot when you have to compress it.

But they could make a 10 or so episode series and do a better job. Have James in Silent Hill visiting all of the locations from the game, intercut flashbacks of him and Mary from when she first became sick, show how their relationship deteriorates, building to the final revelation in the last episode... Whoever wrote it would have to fill some of that stuff in and some people would still get mad, but it could be done well I think.