Anecdotally, I've noticed that a few tags on a site I frequently visit tend to be associated with questions that are off-topic (e.g., > 70% of questions with that tag have been closed).
Is there a systematic way to find such tags? For instance, is there a way to find all tags where most questions with that tag have been closed? Or, a way to find all tags where most questions with that tag have a total vote score that is negative? I can't figure out how to do this using search, but maybe there's some clever way to do it with SEDE.
Motivation: I want to identify tags that could most benefit from having a tag wiki excerpt that provides clearer guidance on the site's expectations. If I notice that most questions with that tag have been closed, I can then write a tag wiki excerpt that clarifies our policy and scope. But is there a way to find such tags in the first place?
Related: Tags with high frequency of off-topic/wrong-site questions asks what to do with such tags, but not how to identify them; Prewarn users that question may be off topic based on tags proposes some specific changes to how the site works for such tags, but I'm asking how to identify them, not suggesting any changes to site functioning.