Not all of them get that much love, but often they have pretty nice functionality.
I still remember that setting up Apache Skywalking was one of the easier ways of getting some APM and tracing in place, compared to the other options out there.
And, of course, the likes of Apache2 and Apache Tomcat are also quite useful in some circumstances.
Sometimes I do worry about the long term survival of the ASF. Many projects are largely supported by 1 person. A lot of projects are mostly abandoned (but not yet moved to the attic). Many others suffer from the blight of "what the hell is this for?", where their website is so vague that it might as well not exist.
The community was especially helpful, responsive, and patient with my limited understanding of their tool.
In the end it was the most stable part of the overall project operationally speaking.