Can't this be solved using a remote file system these days?
I haven't done it in years since with every customer from the last few years the only official way to get to prod is a CI-pipeline, but I think I remember using sfpt or ssh-based file systems even a decade back?
>>eitlan+(OP)
You can use a remote FS but it is nowhere close to the experience VSCode gives you. For instance, running code will run it locally, not on the remote machine.