Works well
Got this working decently enough. I was able to set it up to my local Raspberry Pi pretty simply enough. A few things to note: it does not seem to like "<hostname>.local" addresses, but IPv4 address works well enough. If you change the configuration, make sure that you select another location in the Files app, then go back to SFTP File Provider, it will then update properly.