Spray foam insulation is typically priced by volume, meaning your cost will depend on how much material you need to use to insulate your space, although other factors may influence price as well. In most cases, the cost of spray foam insulation is more than worth it, as it's a once and done upgrade that will not only provide energy savings in your home, but also improve your home's overall comfort.
As this example illustrates, it's important to seal the envelope completely. One of spray foam's biggest selling points is its air-sealing ability, but it can't seal places where it's not sprayed. One of the nice things about using spray foam in new construction is that you can do a Blower Door test before the drywall goes in. Even better, you can test for leaks with a fog machine.
I am building a house in Central Texas (Caldwell). Several builders are cautious about using foam insulation and/or a closed attic. I would like to use both. Here in Texas, heat and humidity (except for the past few years of drought) are a continuing problem. Which type of foam would be the best to use in our home, where should the vapor barrier be or should be use one at all, if we are using fans in the exterior walls to supply fresh air to the house, do we need a vented attic or will it cause more problems than it solve? I have printed out your article and the blogs to give to my contractors and architect, but I would really appreciate your comments on the products being used in my part of the US. 
Note: The practice of foam insulating the attic has raised eyebrows in the building industry because "standard" roofing techniques call for the attic to be ventilated; however, in a vented attic situation it will become approximately 130 degrees in the summer. There's no reason for an air-conditioning and vent-ductwork to have to work in that type of severe conditions. By applying Icynene right on the underside of the roof deck, the severe temperatures no longer exist in the attic. In short, the attic is now a "conditioned" space of the house that is just as comfortable as any other room in the home. This is called a "Compact Roof", which means you can frame right up against it. The one drawback of using expanded foam on the inside of the roof is that this will cause the temperature of the shingles to rise, but how much is not yet known. And how much damage a rise in temperatures could cause is debatable.
One thing I wanted to mention was that I think your price point is a little high and that might deter people from considering spray foam. As a project manager for a spray foam company for years I can tell you that we offer 0.5 Lb. open-cell foam at around $.25/board foot. We even offer a 1.0 Lb. open-cell foam for less/the same cost as you quoted the 0.5 Lb. foam for above. The 1/0 Lb. open-cell foam has an R-value of almost 5.

Roof Coating Denver Colorado