Execute tests via CMake try_run or other mechanisms

[M2-TE]

Some tests are meant to be executed and should therefore be run in CI as well.
The easiest way is to make use of try_run, which would work for both the CTest and non-CTest test versions.

The only issue would be that the required CMake version needs to be bumped to 3.25. That could be solved by only bumping the version required when tests are enabled.

[sharadhr]

I don't think try_run is a good mechanism for running tests, even if it exists. We should use the shell and directly launch ctest instead.

When you have a CMake-shaped hammer, everything is a CMake-shaped nail.