MacFusion is a great program that allows you to mount (S)FTP connections in Finder. It works very well, even in Snow Leopard. However, it’s beta-y, and a little finicky in the latest version of Snow Leopard. Thankfully, Google to the rescue!
The short version: Open system preferences, allow beta versions of MacFUSE, then run: