Not necessarily, but there's some correlation. Games widely praised either are quality games or they resonate with their audience in some particular way, which can be itself an indication of value. Conversely a game that is widely panned might have some significant flaws or be lacking in some fundamental way.

Sure, there is always the odd Garfield Kart meme and some controversy skewing that. But because lists of reviews are easily available on the store page you can look at what is it that the other customers are praising or criticizing, and make your mind based on whether you see merits in these opinions.

Overall, even if you don't trust popular opinion, it's still a very useful tool. Frankly, often more useful than mainstream game reviews that tend to be overly lenient with triple-A publishers, and neglect indies.