find_package: Improve --debug-find-pkg= when using a find module
Extend the feature added by !6778 (merged) to enable debug output for find_*
calls within a find module or cmake package configuration file.
Also improve formatting of the debug-find messages.
Fixes: #23211 (closed)
Backport: release