For fully local things like docker containers or across lan, its comparable if you use SSHControlMaster.

Also, the emacs approach uses very little resources. This matters if your LSP server takes 80% of your RAM. Vscode takes 20%, emacs/tramp doesn't.