From personal experience, I have come across numerous questions that appeared to address the exact issue I was struggling with, only to find them closed as duplicates, off-topic, or something similar. Often, the suggested alternative Q&As are unrelated except for the surface-level similarity, which is especially frustrating.
Sometimes, when I find one of these closed questions, I feel a strong sense of empathy towards the asker, as if I'm the only person out there who understands them.
Unfortunately, I have always been primarily occupied with whatever problems I was dealing with at the time, so I don't have a list of examples I can share with you.
SO is undoubtedly a valuable resource, and I don't completely disagree with the moderation style. However, it has been a slow burn for me.