You've got no argument from me there, Dennis. Getting a good installer if you're going with spray foam is crucial. Many builders or homeowners don't know how to find one, however, and that's where third party inspections come in. Also, even good installers have bad days, but if someone comes in behind them with a measuring probe and a Blower Door, there will be fewer sub-par foam jobs.  
Spray foam insulation, when properly installed is both an air barrier and when closed cell foam is used at the proper depth a vapor barrier!  Before hiring any contractor you should establish the brand of foam being used and verify that with the named manufacture.  Please ask for ESR reports and MSDS sheets on any foam being installed in your home. A couple areas where you might consider spray foam insulation include:

I don't even want to ask this question but... several years ago we hired a local contractor to spray high density foam on the roof deck and walls of our unfinished 2nd floor. We realized that the job was done poorly and cut an access into the attic space to assess things. We realize now that they spray foamed directly to the chimney (no flashing). The chimney is currently used for a woodstove and DHW venting. The DHW will go away but wood stove will remain. My question is, how bad (unsafe) is this? I have found information on foam exposure to fire but have not been able to find anything about temperature ratings in general (i.e. what happens on prolonged exposure to high temperatures).
A: The RV roof coating works by waterproofing, weatherproofing and sealing our RV roofs from elements, including rain, snow, wind and other outer forces. It can also resist impact from leaves, twigs, dusts and other things that would otherwise damage the roof. It also works by reflecting UV rays, keeping the roof from degradation. The roof coating can also prevent leaks, heating and cooling loss and discomfort in our RV.
Closed-cell (aka two-pound foam) is denser than open-cell at about 2 pounds per cubic foot. Its R-Value is between 6-6.5 per inch. As a result, this kind of foam is much more expensive than its counterpart. The reason closed-cell doesn't need a vapor retarder is because it already has one. It's permeance is 0.8 perm, which means it can handle cold climates without the use of an additional board or drywall. Closed-cell uses hydroflurocarbons (HFCs) as part of its makeup. However, this material has been known to have a high global warming effect. If you want a green insulation solution, this is not the material to use. A way to avoid this and still use closed-cell is by installing it alongside fiberglass batts.

Spray Foam Crawl Space

If you’re not familiar, spray foam is a type of insulation that expands after you spray. The foam expands and seals, avoiding any type of unnecessary moisture (which can create mold) or encouraging pests to eat through your walls. It protects the lining of your house, and even can protect the heating and cooling of your house during those unbearably cold or hot days.
The problem was that the installer was doing his first spray foam job ever, and the thickness of the insulation varied from zero (visible roof deck) to about 9". Unfortunately, good average thickness doesn't cut it. The coverage needs to be uniform because a lot of heat will go through the under-insulated areas. (See my article on flat or lumpy insulation performance.)

I recently did a remodel project for my basement using spray foam insulation. The original builder has used fiberglass, but I wanted the best insulation i could find. We chose closed cell foam because it blocks moisture from getting into the house. It took one day to install and was fumey for about 3 hours. It was pretty cool watching it being done. It comes out as a liquid and then expands rapidly into a foam. It's quick! Then they took a types of saw to shave it flat with the wall studs so we could then go ahead and drywall.

Roof Coating Denver Colorado