"late" profiling detail should NOT fall back to `-fprof-auto-top`.

I think it is potentially very confusing and unexpected that the `late` profiling option (inplemented in #8528) falls back to `-fprof-auto-top` if your compiler version is too old. If you are specifying late detail you are not expecting the profiling option to affect the runtime characteristics of your program, because the cost centres should be inserted after profiling.

I think it makes more sense to only place cost centres if your compiler supports the requested mode.

In general, I find it a bit surprising that options are silently ignored if they are not supported, for example, if your compiler doesn't support `parMake` then the `-j` option is ignored without warning.

cc @AndreasPK