I will try to remain reasonable and polite in responding, but it will be hard.
Glass or rock wool fiber batts are rated for their insulation value with ZERO air movement and perfectly dry. That, sadly, is a condition only possible in the test lab at manufacture. The only way you can get half-assed performance from insulating batts is with a full and effective vapour barrier. Now, in a house behind protective drywall, that IS possible (and the outer wrap used these days takes care air and moisture leakage and circulation from the outside of the envelope. IF you can do these things, you can achieve what is claimed for batt type wall or roof insulation. However, my experience with shop buildings is that you will be hard pressed to maintain that (my own home shop was done with 6" foil-backed glass fiber 38 years ago, but the foil backing has all failed and I need to remove it all and will replace with sprayed-in-place foam). BIG job!!!!!
When it comes to sprayed foam, however you need to know with certainty the characteristics of the foam being applied. Look at the table below and you can see that P/U foam can be open or closed cell. In my experience, very low density foam (i.e. lowest cost) tends to be open cell. You need to know you are getting closed cell from a reliable, honest and technically competent contractor.
Now, you are not exactly up here beside me where the Canadian National Research Council has established best practice for insulating an energy efficient building is an R value of 60 in the roof, 40 in the walls and I forget the value under the pad (assuming slab-on-grade construction). IIRC, the US NRC is somewhere around 50 roof, 40 wall for Iowa. To reach these values, a Canadian or US wall in perfectly done fiber batts would be 12" thick and a Canadian roof more like 18 vs. US under ideal conditions 15". You could reach the same values with CLOSED CELL PU 6" walls and 8 US or 10 Cdn roof. The big upside to sprayed foam is fantastic vapour barrier. Movement of air is exceedingly important to achieving target insulation values.
What I see most often is retrofits of 2x6 glass batt walls (R20) with 2" foil faced polyisocyanurate board on the outside (R16) and replacing glass batts in ceiling/attic with 6" of closed cell spray foam (still only R50).
I have been debating what to do in my next (last) shop and think the only way I can reach R60 on roof is with a built up roof of 2 layers of 4" foil back board. Want to build in MIPs, but nobody seems to make anything beyond 6" (that DOES give a workable R50).
Don't forget the underside of the pad. Our resident concrete guys will give their reccommendation, but mine would be 2" of PU board...NOT styrene (IMHO not stable enough and too easily absorbs water). I will be using PFCC (cellular, very light weight concrete) under my pad instead of plastic materials.
Yes, decent insulation is EXPENSIVE, but energy costs are going to go nowhere but up. I am not in the insulation business, but have a friend who is to do so reality checks with.
For those who really want to know, here is the NRC Energy Star programme information:
https://www.nrcan.gc.ca/energy-effi...gy-starr-new-homes-standard-version-126/14178
| Material | R-value/in | 3 1/2" | 5 1/4" | 10" | 12" | 15" |
|---|
| Fiberglass (batt) | 3.1 - 3.4 | 10.8 - 11.9 | 16.3 - 17.8 | 31.0 - 34.0 | 37.2 - 40.8 | 46.5 - 51.0 |
| Fiberglass blown (attic) | 2.2 - 4.3 | 7.7 - 15.0 | 11.5 - 22.6 | 22.0 - 43.0 | 26.4 - 51.6 | 33.0 - 64.5 |
| Fiberglass blown (wall) | 3.7 - 4.3 | 12.9 - 15.0 | 19.4 - 22.6 | 37.0 - 43.0 | 44.4 - 51.6 | 55.5 - 64.5 |
| Mineral Wool (batt) | 3.1 - 3.4 | 10.8 - 11.9 | 16.3 - 17.8 | 31.0 - 34.0 | 37.2 - 40.8 | 46.5 - 51.0 |
| Mineral Wool blown (attic | 3.1 - 4.0 | 10.8 - 14.0 | 16.3 - 21.0 | 31.0 - 40.0 | 37.2 - 48.0 | 46.5 - 60.0 |
| Mineral Wool blown (wall) | 3.1 - 4.0 | 10.8 - 14.0 | 16.3 - 21.0 | 31.0 - 40.0 | 37.2 - 48.0 | 46.5 - 60.0 |
| Cellulose blown (attic) | 3.2 - 3.7 | 11.2 - 12.9 | 16.8 - 15.0 | 32.0 - 37.0 | 38.4 - 44.4 | 48.0 - 55.5 |
| Cellulose blown (wall) | 3.8 - 3.9 | 13.3 - 13.6 | 19.9 - 20.8 | 38.0 - 39.0 | 45.6 - 46.8 | 57.0 - 58.5 |
| Polystrene Board | 3.8 - 5.0 | 13.3 - 17.5 | 19.9 - 26.2 | 38.0 - 50.0 | 45.6 - 60.0 | 57.0 - 75.0 |
| Polyurethane Board | 5.5 - 6.5 | 19.2 - 22.7 | 28.9 - 34.1 | 55.0 - 65.0 | 66.0 - 78.0 | 82.5 - 97.5 |
| Polyisocyanurate (foil-faced) | 5.6 - 8.0 | 18.2 - 28.0 | 29.4 - 42.0 | 56.0 - 80.0 | 67.2 - 96.0 | 84.0 - 120.0 |
| Open Cell Spray Foam | 3.5 - 3.6 | 12.2 - 12.6 | 18.4 - 18.9 | 35.0 - 36.0 | 42.0 - 43.2 | 52.5 - 54.0 |
| Closed Cell Spray Foam | 6.0 - 6.5 | 21.0 - 22.7 | 31.5 - 34.1 | 60.0 - 65.0 | 72.0 - 78.0 | 90.0 - 97.5 |