I don’t have much of a problem with the small open source projects that are generally very good at filling gaps or addressing niches.
I think most of the waste is coming for the development done by the large open source houses. The canonical and red hats of the world. They should stick to what they are doing well, which is the foundational stuff.
At least what you are looking for, is on the first page. With Google you get half a page of ads not relevant to your search, and two pages of SEO garbage, before you get to a relevant search.