At some point the needle to hay ratio becomes untenable and searching the whole haystack is no longer possible for a single person. You can still randomly sample the stack, though, and rely on the opinions of others to find what you personally missed, and good games with mass appeal do tend to rise a little bit from random players stumbling across them; maybe not to blockbuster status or even profitability, but enough that a game with a marketing budget should get more than 21 Steam reviews if it's genuinely appealing. There's really not a lot of cream at the very bottom.
And that isn't just some sort of academic point I'm making. Seemingly the overwhelming majority of indie success stories are achieving long-tail success now a days. Increasing numbers of indie games released like a decade ago are having better play figures today than they did at launch. This includes both the extremely well known titles like Terraria [1], as well as those that are still relatively unknown like Kenshi [2].