While there are a couple apps that technically work, I ended up deleting them because it wasn't a very good experience. My conclusion was - just buy a dedicated web cam. They're so much better.
The fatal flaw in all iPhone/webcam setups is you've got to leave an iPhone plugged in and on and active (unlocked) while its acting as a camera.