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