I've been touting the benefits of Spray Foam Insulation for years. It is actually incredible how much money you can save on HVAC every year. Your Heating and Cooling equipment can be halved in size and your living space is draft free and incredibly comfortable. Mate this with geothermal and your utility bills to heat and cool are equivalent to someones Starbucks habit (maybe less). If the North American building code…
Spray foam is very expensive and is not sustainable. Mineral wool/rockwool is also fairly popular but pricey as well. Also, it's not just adding insulation. Air tightness is hard problem to address for existing houses.
The average home has 2000 ft of linear cracks. Everything from poorly sealed doors, windows, and envelope. It's like the equivalent of keeping your front and back door open all year around. So even after spray foaming there is some leakage (blown door test).
Really, Spray foam isn't that expensive, you should be paying about $3 -$4 a sq/ft at around a R-21 which is cheaper than most tile or carpet installations.
https://huntsmanbuildingsolutions.com/en-US/
If I were building a house I would probably go with ICF forms all the way up and Spray Foam the attic and basement floor (under the concrete floor). If I were renovating, I would Spray Foam and try to make the job large enough to cover the contractors minimum charge. Even a couple of rooms can really help the utility bills.