I guess I've moved to the part of my career where Stack Overflow isn't that helpful, but I've found a lot of utility in searching issues on GitHub and Reddit posts.
I'm right there with you. It's nice to know it's been there if I needed it. I don't find myself there very often anymore and when I do it's often to compare official docs to other ways to approach something or because the getting started section of the official docs felt weird or wrong.
But are they losing the first positions because they're losing relevance, or is it due to other sites abusing seo and search engines abusing from advertising results?
Many queries don't find relevant questions, and the relevant questions are often not answered properly. I often find the exact same problem I'm having, but the answers are just a bunch of those CV padders that post completely irrelevant answers based on a buzzword they saw while skimming the question.
When I do find relevant answers, lately they're all so old that they no longer work, or rely on now deprecated functionality of a library or system.
Finding code snippets for interfacing with Azure through PowerShell is a crapshoot because Microsoft keeps deprecating different PowerShell modules for it.