You'll find these documented right next to C-x M-c M-butterfly. ;)
Though in practice I find that (a) once you know emacs it's usually just as easy to shell into the remote machine and run emacs there, so I myself have yet to really get the hang of Tramp and (b) the vanilla Terminal app plus a properly set-up .sshconfig goes a long way.
What I usually did was to run Emacs on my dev machine, run multi-hop Tramp to get to any of the production servers via a gateway jumpbox. Tramp is able to do multiple ssh hops to get to the target machine, all behind the scene.
Bookmarking the remote files makes it really easy to get back to it.
If you're on a Gnome-flavored Linux, then many "lesser" editors can use GVFS to remotely work on files.
I installed this one but I don't like it :/
honestly, my main complaint is just about eclipse itself. for some reason id rather be using something more "cool", but eclipse has always just done the job for me.
I already thought about writing an own editor exclusively for that, but it's too much work to build everything from scratch imo.
Also if you use any desktop linux system, the default text editor can probably open files on remote machines (with a wide variety of protocols), just enter the url. In Gnome it's called the Gnome virtual file system (GVFS).
bbedit also has unix shell script support and worksheets that can run one-liners. i don't use it much, so i can't really say how well it works or how useful it it. but i guess it would be possible to do what you describe, and given that it's bbedit, i'm inclined to think it would work intelligently and well.
i'm not affiliated with the company, but i've used bbedit since about 1997. i can see how textmate is superior in some ways, but it lacks some bbedit features that i use a lot so that makes it hard to contemplate changing -- just like the emacs graybeard who also commented.
Could some intrepid developer create an app that would allow me to easily a) open and edit remote files b) open arbitrary terminal windows that are already ssh-ed into my build server so I can grep/find/make/whatever else I have to do. This would be the killer editor for me and most people I know, and it pains me every time I see a new editor that doesn't do this.