Honest question: doesn't sshfs solve this problem? I've never understood the appeal of TRAMP, mounting the remote resources seems like a much better and less finicky solution.
TRAMP also feels faster to me; I presume it's due to background jobs adjusting their casual I/O usage when TRAMP is detected, like writing backup/lock files, scanning directories for VCS info, etc. which has high latency on SSHFS.
I also like using `/sudo:root@localhost:/foo` for editing local files with different user permissions (plus the same command and terminal behaviour as with SSH)
/ssh:you@remotehost|sudo:remotehost:/path
Doing any further actions on a file opened that way also applies the hops there as well. For the example above opening a shell or running a shell-command would run those through sudo on the remote host.[0]: https://www.gnu.org/software/emacs/manual/html_node/tramp/Ad...
Tramp is agnostic in most things (well, you need an ssh client at least).
These days I just tmux on the server, open emacs and hack away (as long as you can install things on the server).