I use it with ST2 for my editor, directly saving onto my remote dev box, and it works fairly well. My biggest hangup is actually with ST2 - I can't individually refresh project sub-directories, only the main one, and saving files in ST2 is a blocking operation -- can't do anything else, and when a save takes a couple of seconds, it can get frustrating. I've tried the SFTP plugin for ST2 and I still prefer this route.
Open Source and the fastest client https://code.google.com/p/win-sshfs/
Free, but with limited functionality. http://www.eldos.com/sftp-net-drive/
Best UI, but way too expensive. http://www.expandrive.com/
They're all somewhat stable, but their performance is far from as fast as Linux SSHFS. Win-sshfs is much faster than Expandrive and Eldos SFTP, but slightly more buggy.
Of those three I recommend win-sshfs, Expandrive would have been worth it if its pricing were not so extreme. You get support though!