These are only a few instances of places on Stack Overflow where community curation of larger material has worked. The C++ community on Stack Overflow is very careful and protective with https://stackoverflow.com/questions/388242/the-definitive-c-... . But outside of that, most people let questions and answers rot.
Fun and interesting can happen when it doesn't become a distraction for the site as a whole. MathOverflow, with more active curation that is possible with a larger active contributor to overall community ratio is able to handle list questions ( https://mathoverflow.net/questions/tagged/big-list?sort=vote... ) in a way that has often failed to be curated well on Stack Overflow.
The "less likelihood" is a binary thing. Stack Overflow can't say "index this, but don't show that result often" to google. Google does what it wants. The way to remove noise to help with the signal for that vision of good programming knowledge is to, well, remove noise. People up voting fun things makes that signal for good material even harder to find though.