To me, it makes no sense to use spray foam. It would just be a mess to clean up.
I find 2" of foam board in the ceiling and 3/4" of foam board in the walls and floor to be plenty. And that's in the middle of Idaho. Even on chilly nights, you need to crack open a window and the ceiling vent, or...