During the last decade that I've been asking/answering questions I only ever had 1 question locked as offtopic, and it was when they introduced question types. The several questions which I did report as invalid/offtopic/etc. were just error messages thrown by compiler without any substance of what you are supposed to look at to even determine how to help the author.

I'm genuinely confused whether people just parroted the memes or actually had their questions closed.

Bullies -- people just looking to tear apart questions -- always have lower cost to answer and higher reward for answering than people looking to be helpful.

That said, the SO moderation was so awful I don't think it's correct to blame the downfall on the bully dynamic even if it was clearly present and might have eventually overrun the platform. I used to joke that an answer wasn't uniquely useful unless it had been locked as duplicate, but it wasn't really a joke: I kept a tally on a sticky note and of the posts I found useful, incorrect duplicate flags outnumbered open questions.

I asked two questions which were both locked as dupes. The referenced questions mine were supposed to have duplicated were not, in fact the same question. After that I didn't bother. If I could find my answer with a search engine, fine, but I wasn't going to waste time trying to engage on the site.