[bluGill]

Foam is expensive, and thus for the same profit margin (expressed as a percent) there is more money. Foam thus puts a lot of money into shows like that for advertisement.

Closed cell foam is the best insulation - if it is installed correctly. You should want it as it is the best insulation. However the payoff is several decades vs much cheaper insulation and so most people find it isn't worth the costs.

In general, for most houses, putting in the most cheap insulation you can, and then investing in a heat pump is the most bang for the buck and better for the earth than the most foam you can and then using a much less efficient HVAC system (in a new house this is typically what code requires, but there are a lot of old houses with minimal insulation and a terrible furnace).