Ah, not so much.
sshfs is the generic linux way of accessing another device's filesystem as though it were part of the computer's filesystem.
calibre's "Connect to folder" has no hard dependency on sshfs -- you should be able to use it with any folder that appears in your File Explorer.
It certainly won't allow you to use one of the auto-mount-detected device drivers.