Work around library loading issues and test shared lib loading

This MR hopefully fixes Python BCs together used together with the Python wheels. Problem reported on the forum.

The MR adds ctest checking shared library loading, too. And some more ctest log aggregation such that one can easily see which tests failed for all jobs combined, see e.g. here (might vanish soon).