[FEA]: Improve handling of CUDA_HOME and CUDA_PATH in build across projects

[Andy-Jost]

Is this a duplicate?

• [x] I confirmed there appear to be no duplicate issues for this request and that I agree to the Code of Conduct

Area

cuda.pathfinder

Is your feature request related to a problem? Please describe.

Refer to comment: https://github.com/NVIDIA/cuda-python/pull/1395#issuecomment-3716120282

Describe the solution you'd like

Implement the changes in the linked comment, ideally in pathfinder.

Describe alternatives you've considered

No response

Additional context

No response