Yes indeed, spray foam has to be done correctly, on properly prepared surfaces. Additionally, since it does dramatically reduce air infiltration, care has to be taken to insure fresh air properly de-humidified (ERVs), even here in NH which is pretty dry. Our home (10 years old) uses a combination of 2” dense foam and 6” of compacted cellulose, providing a R-50+ wall. Ceilings have 3” more cellulose. Blower door testing shows virtually no air infiltration and energy costs for our 100% electric home are pretty reasonable, even with local high prices.
This (and lots of other details) investment in energy conservation was why I was so interested in Sense when I saw it featured on a TOH show two years ago. Unfortunately, it’s inability to function properly in a “noisy” (constant pressure deep well pump) environment has limited its usefulness detecting most of our home…including the noisy well pump itself.