Fix Python cross-platform issues.

[clegaard]

Currently, locating Python using the find_package works very poorly on Windows
https://cmake.org/cmake/help/git-stage/module/FindPython3.html

A number of workarounds need to be employed to ensure that the libraries can be found.
Also msys2 installations seem to be problematic since they also contain a python distribution.

Unfortunately, no package is uploaded to conan for Python. But a project exists that provides a cmake recipe for Python:

https://github.com/python-cmake-buildsystem/python-cmake-buildsystem

This would remove the issues with having the correct python distribution etc.

[clegaard]

On windows a number of factors were causing problems finding the correct python library.
Closing as it does not seem to be present anymore on my own PC or when building on github actions