I have been looking at using spray foam insulation in my upcoming home build. Everytime I mention it my builder get this funny looks and mentions how much extra it costs. He says that his HVAC guys don't reccomend it and are not willing to resize/downsize tonnage based on spray-foam.

Does open or closed cell spray foam insulation work to reduce noise, air infiltration, and improve efficiency? Will I be able to reduce the necessary tonnage of my HVAC unit?

Any help in clearing the confusion is much appreciated.