find_package: Improve CMP0074 warning messages
Policy CMP0074
was added by !1858 (merged). Revise the logic to avoid warning when a PackageName_ROOT
variable is set to empty since that won't change the search behavior. Also, when we do warn include the variable value(s) for reference.