This is THE Mac Finder App that I have been hoping to find.
FileBrowser - US App Store

FileBrowser

Currently Version 1.6

Overview

FileBrowser is like having Windows Explorer or Mac Finder on your iPad to access, copy and stream files from remote computers including Windows, Mac, and Network (NAS) drives.

You can browse to machines on your home network and view documents, photos or stream movies directly to the iPad without needing to sync them through iTunes. You can also transfer files wirelessly to your iPad to take with you.

Use FileBrowser to connect over the Internet to folders and files on networked servers or workstations. Just as you have all your e-mail at your fingertips, you can now have all your files, folders and documents, direct to your iPad. - To connect to your computers without using WiFi away from your home or office you will need either a Virtual Private Network (VPN) or will need to port-forward Internet SMB traffic.

FileBrowser allows you to launch documents, spreadsheets and images into your favourite app for editing too!

No additional software is necessary on the remote computer.