I like the idea of that single-file Python script with inline dependency info construct, but it's probably going to be a bummer in terms of editor experience. I doubt the typical LSP servers will be aware of dependencies specified in that way and so won't offer autocompletion etc for those libraries.
The script dependency metadata _is_ standardized[2], so other LSP servers could support a good experience here (at least in theory).
[1] The Ruff Language Server: https://astral.sh/blog/ruff-v0.4.5
[2] Inline script metadata: https://peps.python.org/pep-0723/
Given this is a recently accepted standard (PEP 723), why would language servers not start to support features based on it?
Consider an editor feature, e.g. goto-definition. When working in a normal Python environment (global or virtual) the code of your dependencies actually exists on the filesystem. With one of these scripts with inline dependency information, that dependency code perhaps doesn't exist on the filesystem at all, and possibly won't ever until after the script has been run in its special way (e.g. with a `pipx run` shebang?).