cmake: replace HIP and SYCL lib hacks

[bd4]

Currently the main CMakeLists.txt file lists libraries needed for blas and fft for both HIP and SYCL. This is just a quick hack to get things working until upstream cmake is improved. In particular, the HIP config breaks mixed language builds (e.g. Fortran + C), once this is merged the official cmake support for HIP should work again: https://github.com/ROCm-Developer-Tools/HIP/pull/2190

Also need to explore oneAPI cmake support further.