CMake flags for HIP and SYCL debug builds

[n01r]

Using the flag -g1 instead of -g for the modes Debug and RelWithDebInfo was observed to avoid hanging builds, e.g., on Crusher (OLCF). This could be useful to make a default for HIP and SYCL.

[WeiqunZhang]

In GNU Make, we use -gline-tables-only -fdebug-info-for-profiling for Intel's oneAPI compiler. These flags are recommended by Intel VTune for device profiling. For SYCL codes, it produces executables slightly bigger than -g1 does, but much smaller than -g.

[n01r]

@WeiqunZhang, I tested -gline-tables-only -fdebug-info-for-profiling and it compiled successfully on Crusher as well