I regularly use BASF Walltite, a medium density closed cell spray foam, for basement walls, rim joists and odd hard to reach spaces.

But I am dubious about the cost effectiveness of using spray foam everywhere, especially in a mixed-humid climate. More important than the spray foam used is your choice of applicator. The best product (and your build) can be ineffective and indeed a hazard when mixed and applied by poor operators.

You might post in renewable energy forum....there are folks with knowledge of insulation there.