I think uv[1] basically solved this problem for python scripts. Go creates statically linked executables that are easy to deploy.
1 - https://docs.astral.sh/uv/guides/scripts/