[CUDA] Improve the loading process of the CUPTI library when tracing

[pasaulais]

#1070 uses a hard-coded path for the CUPTI library. This might cause issues when using CUDA adapter builds on a different system where the library is located in a different directory. This process could be improved in several ways, e.g. letting the user override the path through an environment variable, checking well-known paths, using the RPATH, etc.

[pasaulais]

According to this comment, on Windows we should ensure that absolute paths are used, to avoid any security issue with loading libraries from a user-writable path: #1070 (comment)