I also heard on this old house, that the foam they use, if say a roof would leak the water would go straight through it and not effect it at all. Is that all the expanding foam or is there a particular kind?
I've never heard of that, if thats the case then I can't imagine why air wouldn't make it through.
I've been eyeballing
http://www.tigerfoam.com/
Comparable in price to the Icynene stuff (that I've found), and I'm impressed by their eco-friendlyness, by not using some of the strange chemicals to make things more resistant to fire. Everything comes in a kit too, so the price listed online has everything included. I've yet to compare the price as opposed to having a professional contractor come in and do it, it'd definitely be less of a headache. From the site it looks like they sell to professional installers, so maybe someone around you can do it. it'll all be sealed up in the wall anyways, so I'm not sure even how big of an issue the fire chemicals are going to be anyways.
Also, upon further reading, these companies mentioned tell you to trim off the excess in their product specifications PDF.
I'd still forgo this installer though, by all means call around the area, and possibly try to get some references.
Icynene has both the spray and pouring formula, though it's R value looks like it's about half that of the TigerFoam. Tiger foam = R7 per inch, Icynene = R3.6 for the spray and R4 for the pour. Looks like you get a bit more coverage from the Icynene though.
Tiger foam - 2x4 wall = ~R24
Icynene - 2x4 wall = ~R13
*both figures from each manufacturers site respectfully
Either will do a good job of sealing out the wind and elements.