Can't you ssh into them? If so, in emacs you can just open /ssh:host:path/to/file and remotely edit that file.

Even if you didn't have emacs, I don't think you are forced to use VSCode. You could just use sshfs and use any local editor, but I guess other editors also have remote editing plugins