include/find_package: Warn on case-mismatched module names

Detect when the requested module name differs in case from the module
filename on disk.  Emit an author warning on Windows and Apple
platforms, where case-insensitive lookup can hide portability problems
on case-sensitive filesystems.

Fixes: #27811