I can buy that people like it, I don’t dislike it, but it also isn’t sliced bread. There’s peers in the market that are ahead in various ways, so VS Code isn’t the end all be all, even if it is cool.
I realize sshfs provides something similar, but it has a few rough edges compared to the vs code implementation.
Emacs supports editing remote files via ssh, ftp, or scp; one simply refers to filenames like: /ssh:host:filename or /ssh:user@host:filename. It's pretty simple and transparent. One can browse remote directories, etc.
Likewise editing a local file under a different user id is also supported using paths that look like /sudo::filename.
See section 18.5 Remote Files in the Emacs user manual[1].
[1] https://www.gnu.org/software/emacs/manual/html_mono/emacs.ht...
Something I have yet to try is using an lsp server with a remote project. I'm not sure how some, like the rust lsp, that need the whole project (at least w/ emacs it doesn't yet support isolated files), would work.