I'd teach pg_upgrade to inspect the post-upgraded catalog of in-use dependencies and report on any of these it finds and remind the DBA that this latent issue may exist in their system.
Would this help? Collation-related dependency changes are a different thing from major version DB upgrades
Tom’s point about how the levels are directly tied to concrete differences in behavior (planner/executor) makes a lot of sense to me
