They're a bit screwed because they rely so much on volunteer mods but the volunteer mods are crazy...
And the community is tired of people asking for help with their homework or doing very little effort themselves before asking. Why do these people deserve others spending their time helping them if they can't even bother to search or formulate something coherent?
I don't think anyone objects to closing those questions. That's not really what this is about. My questions are very clearly not asking for help with homework and trivial "how do I write a for loop" or "it doesn't work" questions. Still get downvoted/closed frequently. Most often:
* It gets closed as duplicate because there's a vaguely similar - but different - question. Or sometimes there's a completely different question with an answer that incidentally also answers my question.
* It gets closed as too vague or not clear because it's simply outside the domain of expertise of the voter. It's clear to people that know what I'm talking about.
To be clear when I say "mods" I don't exclusively mean people with official mod power. It's also people that moderate for fun - those that trawl the new questions. Let me know if you have a better name for those people.
You can tell it's them because you very often get a couple of downvotes immediately and then if you check back a month or two later it will have been upvoted by many more people that actually had the same question and arrived there via Google.
Getting something closed as a duplicate shouldn't be taken as a slight. It's often good that various formulations of a question then can point to the same answer. Or if the answer to the other question answers yours, isn't it just good that you and other people will be directed there? It's a Q&A site, not a forum. Which question stands doesn't matter except for feelings.
Same with your vague or clarity. It's Q&A, not a forum with back and forth discussions. It's just not a right fit. You might think that's not how you'd like the site to be, but it is how it is. It's not overzealous moderators closing it.
Fact is, nobody wants to go to Stack overflow anymore for answers because the experience sucks. And they don’t mind using ChatGPT. Thanks for all the training data, Stack!
But just like with antibiotics, bugs were trained on it and they got stronger finding the exploit until spam, scam and greed destroyed it once again. Sigh!