I've switched all my scripts to include their own dependencies, and it works like a charm.

Only problem I haven't been able to solve is how to convince my IDE (PyCharm) to run all scripts through uv before executing them / debugging them.

PyCharm does have uv support, but from what I can see only for uv managed projects, not for individual scripts with embedded requirements.