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.