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.  
I used this product to seal and insulate my rim joists as I am finishing the basement. The builder used R13 batt insulation when we built the house 3 years ago. I use a dehumidifier to control moisture in the basement which is below grade. The setting I use is 55%. The dehumidifier kicks on periodically and requires emptying every few days. Since using the foam all around the house on the rim joists and sill plate, the dehumidifier has stayed at 50% for over two weeks since spraying and rarely turns on anymore. I also put the original R13 batt insulation back up after the foam cured. 

I have never used foam insulation before and this was easy for me to use right out of the box. I had a 4'x8"x8" cavity in my basement that houses a waterline. When the previous homeowner installed this they put no insulation in at all and being that it's an exterior wall in the basement and I live in the Midwest that thing was pushing so much cold air in it was incredibly uncomfortable. Out of the box and job completed in about 5 minutes. Stopped all drafts and created a nice 2" barrier on the wall in which I will install some extra bat insulation over it. 4 stars because the spray isn't very good passed 6-8" from the surface. Make sure you can reach the surface you want to coat. Great for small jobs!
During colder months, 2 component foam is very sensitive to temperature variances. Per product instructions, both tank temperatures need to be above 70°F (21°C) for at least 24 hours prior to use. All application surfaces should be clean/dry and above 60°F (16°C) prior to application. Variance outside of the recommended temperature can affect foam yield and performance.
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.

A. You can use closed-cell spray foam that way if you want, although you should realize that the spray foam will prevent the roof sheathing from drying inward. This approach should only be used if the roof sheathing is bone dry, because it will never dry when sandwiched in this manner. Most building scientists would prefer to see fiberglass rather than closed-cell spray foam under the roof sheathing in this type of assembly. 

Roof Coating Seal