Mounting a remote SCP or SFTP share on Mac
Seems https://mountainduck.io is where it's at:


  Mountain Duck lets you mount server and cloud storage as a local disk in the Finder.app on Mac and the File Explorer on Windows. Open remote files with any application and work like on a local volume.


If you find other alternatives, add them at https://alternativeto.net/software/mountain-duck/