I’ve used Cyberduck (which is very cool) and before that sftp and at some stage I even worked out how to use scp.
Recently I took on putting up a web site and for that I ended up using MacFusion.
The short version is that the file system where my ISP allocated space for the website shows up as a mounted disk on my desktop – which makes managing site content a snap. (As a bonus, by installing ntfs-3g I also get to mount NTFS volumes for read/write access)
The long version is a great example of how technical content can be presented powerfully.