As someone who writes about iOS software and jailbreak tweaks for a living, I am constantly using software to connect to my devices. The right software can make it a snap to access the file system, transfer photos, manually install software, and make backups, but the wrong software can make your work flow slow to a crawl.
This is an overview of some of the most popular tools for browsing the iOS filesystem from a computer. Depending on your preferences, you might choose one tool over another...