Is there an equivalent for Vim?
Out of the box, you can edit remote files with
> :e scp://user@myserver[:port]//path/to/file.txt
It creates a temporary copy and upload it on save.
For more complicated editing, sshfs would be the way to go. I don't know if there's a plugin that can simplifies all this... probably someone somewhere did something but is it stable and maintained?
Remote development with TRAMP was the main thing that kept me on Emacs. Once VSC offered a credible alternative, I switched.