I think "Mixed" is where Steam reviews falter, at least for me. If a game is mostly negative it's usually bad and if it's very positive or overwhelmingly positive it's usually good. But I've certainly had experiences with several games that are much better than "Mixed" reviews would indicate.

"I really wanted to like this comment but I think the writer has now abandoned it. There have been no updates and I think maybe AI was used for some of it. It also crashed my browser 5 times. I'd ask for a refund but writing this comment took me past the 10 second returns window."

Joking aside, the problem with the Steam review system is that people tend to read negative reviews before they pay any attention to positive ones. As a result it has turned into a massive platform for review bombers and personal drama sandbox for entitled attention seekers. There isn't any good faith left in any of it. I've learnt to ignore 90% of the reviews now and have ended up playing some excellent games I wouldn't have otherwise.