[Improvement]: Improve CLI startup time

[Mark90]

Running a command as simple as python main.py db --help takes 1 second in a small codebase like the example-orchestrator. In SURF's orchestrator repository it takes between 5 and 8 seconds.

Investigate what the main slowdown is (likely the product/workflow imports) and how this could be improved.

[Mark90]

(very) Partially done with splitting off main.py to wsgi.py, although docs need to be updated on that (#1152)

On a related note it will be interesting to track the progress of https://peps.python.org/pep-0810/ in the future which should land in 3.15