I suggest to see tramp-rpc https://github.com/ArthurHeymans/emacs-tramp-rpc, for me it improves my connections, making tramp more useful in my daily flow