Yeah once I progressed past junior level work the value of asking questions on SO fell off a cliff. At that point most of the problems I got really stuck on were more niche than how to do $standardThing with $CommonLibrary, and there just weren't many people answering oddball questions like that. Even with popular languages like Javascript and Python most of my questions would get zero useful answers, so I pretty quickly stopped writing them. I think it's true that SO really didn't do much to encourage folks who would write answers like that to stay active on the site.

It stayed useful as a reference tool for quite a while, for when I needed to look something up that was fairly common but that I wasn't personally familiar with. But as others have said, the way they handled dupes and supposed opinion-based answers was really poor and meant that the top answers got more and more out of date each year. By the time LLMs came around they were strictly better for those kinds of lookups. Strictly better for now at least, LLMs will themselves get enshittified in the coming years.