[Feature Request] Automate detection of unused dependencies

Is your feature request related to a problem? Please describe

This repository has a lot of subprojects, each with its own set of dependencies. This leads to a lot of maintenance in keeping these dependencies up to date. We use dependabot to automate updates but that does not eliminate manual work. See #19347 for a case where a dependency was unused. It would be great to automate detection of unused dependencies so they can be removed in order to reduce maintenance overhead.

Describe the solution you'd like

See #5652 for one possible solution for detecting unused dependencies

Related component

Build