Revisit find_package commands in CMake scripts

When OpenMP support is requested, OpenMP should be REQUIRED (see here). Otherwise, we might get the NOTFOUND linker flag, which is not that straightforward to interpret.

We should check if there is a similar problem in other places.