On my Mac I just use the “connect to server” option in finder to connect to a fileserver and mount it (via either cifs or smb).
Any suggestions on how to connect to my iPad (ideally with integration with the files app)? Happy to pay for it if it is a better app than free options.
I use FileBrowser Biz for this. It can run in a split screen with the Files app for easy drag and drop between them. I’m not sure if the other versions of FileBrowser support SMB shares.
+1 for FileBrowser. I have had zero trouble with it and I use it, primarily, to connect to my home network when home and remote. It integrates with the Files app, so once you connect to the network, you can access all your network files directly from Files. It has practically eliminated my need to use Dropbox.