CMD+click won't work over SSH, but if calling context menu it will show "Download with scp from [host]" option. I believe it does require installing shell integration.