Run config_docs CI check is not run on PRs to only change generated docs (resulting in CI failures)

[alamb]

Describe the bug

There are several times where we broke CI because we directly changed the .md markdown files that are autogenerated, but the CI in the PR did not run

Here are some recent-ish examples PRs that fixed such issues

• Fix function doc CI check #19093
• docs: Fix failing documentation check in CI #17026
• docs: Fix failing CI #17041

To Reproduce

1. Make a PR with a change to a the docs in docs/source/user-guide/sql/scalar_functions.md
2. The CI will pass
3. Commit the PR

However then any PRs that run on code will fail because the autogenerated results will not match what is checked in.

Here is an example of a PR with such a mistake (and I should have known better 🤦 )

• Minor: fix link errors in docs #19088

Expected behavior

let's fix the docs check to automatically run on PRs that change the auto generated files

Additional context

No response

[alamb]

I did make a PR a while ago to try and fix this

• Run config_docs CI check on PRs to change auto generated docs #17046

But it got stake and wasn't merged