Some of it depends on other things, like windows, floor framming and other insulation. The biggest being water entry, with foam, if the water gets trapped in the building, it cannot dry out quickly.
Sounds like a great idea, I have seen it work, and fail.
Read up,
www.buildingscience.com, and do a search from there in the information.
Hope this helps , tell us what you come up with and