[FEA]: Add support for user-opt-in logging in path finder

[leofang]

Examples:

• Conda install cupy CUDA Runtime Version (locally installed) failed to load cudart64_12.dll cupy/cupy#9127 (It contains logs from CuPy's internal search logic for library loading)
• nvmath-python (docs)