Spray polyurethan foam does effectly prevent all six of these heat transfer methods from occurring. These should be the mechanisms by which you judge insulation, in addition to their R-Value. If you're uncertain about installing spray foam insulation, Energy Star has a map that recommends levels of insulation by R-value and cost-effectiveness in the United States.
This is more common with closed cell foam, but it happens with open cell foam, too. Since closed cell foam has a higher R-value per inch, installers generally spray 2" in walls and 3" in rooflines to meet the energy code requirements of R-13 and R-19, respectively. (I'm not going to dive into the energy code here, but these numbers apply to many climate zones, the latter being allowed under the UA tradeoffs rule. See the Energy Nerd's blog on this topic if you want to argue.)
I have to insulate my walls at the end of this week. That does not give me time to procure slow-rise foam, so my stud cavities will be filled with foam before I'm ready to fill the corner voids. I will not be able to drill straight through the corner studs. Instead, I will have to remove material where the studs meet. What sort of tool do you envisioning me holding while I create space to pump foam into my 1972 corner voids?
I live in Baton Rouge LA with a very old and drafty house. There is no blockages in the walls between the crawl space and attic. Lots of critters just come on in. I would like to used closed cell sprayed under house to warm up floors and block moisture. I would like to spray closed cell into attic, but am afraid of enclosing attic due to moisture build-up. Can I spray closed cell against the attic floor in same way as installing bats, thus leaving my venting the same as it always has been. Other ideas? Thanks.
RetroFoam of Michigan has more than 15 years of experience insulating thousands of homes and pole barns across the lower peninsula. We hear a lot of misconceptions about foam insulation and work to make sure we clear up any wrong ideas about foam insulation. Our staff helped us put together this list of misconceptions adding their insights to dispel any misinformation.

Roof Coating Colorado