Results are dramatic, spray foam has been shown to save between 30-60% over standard fiberglass insulation! No matter how you look at it, that is money in your pocket and less energy used.
The 100% air seal will improve indoor air quality reducing mold and mildew getting into the house. Mold and mildew have been connected with allergies and asthma.
Although spray foam costs more than standard insulation many states and counties have "energy tax credits". These can sometimes bring the cost of spray foam down to the same price or lower than fiberglass insulation.