I am not a big fan of foam because of its exorbitant costs.
Foams can easily cost 3-5X more than conventional cellulose or figerglass insulations while providing no more energy saving benefits.
In fact, high density fiberglass can give you an R value equal to most open and closed cell foams and many times less the cost.
Foam insulations used in accessible attics must be also specially isolated from combustion by way of covering them with drywall, mineral wool insulation or other approved thermal barriers. Foams will ignite in a fire causing the flames to rapidly spread and produce noxious fumes including cyandie gas if not thermally protected for ignition. This can also add to the already high costs of their use.
The biggest ultimate drawback with foam insulations is that they can take decades to pay for these exorbitant materials before seeing that money applied to any real dollars saved on energy costs...
And they still do not address all heat loss issues in the structure.
That doesn't make for a very cost effective or sensible way to insulate especially when money is a factor.
That said.
There are two ways to insulate an attic or rafter spaces:
1) By insulating the floor of the attic, or lower portion of your scissors trusses and then ventilating the attic..
2) By insulating the rafters right up against the roof without having the attic ventilated at all.
It is actually #1 that offers the least energy efficient design and most potential damage to shingles. The reason is that the deck immediately under the shingles in such designs will get excessively hotter in summer than if you insulate with a closed attic design. Placing the insulation directly against the underside of the roof deck makes for a cooler roof deck and cooler shingles. This is a perfectly acceptable means to insulate for shingle manufacturers.
Also, despite technically having to heat the attic space when insulating the underside of the roof deck and rafters, studies have shown the closed design in #2 above to be highly more energy efficient than conventional ventilated and insulated attics.
Moisture is not an issue with closed cell foams. Closed cell foams have perm ratings less than 1 making them true vapor barriers. For this reason they can be applied directly to the underside surfaces of rafters or to the joist cavities without worry about condensation.
When placed against the rafters, you are technically 'trapping' gaseous water vapor from the house below in the attic space, but so what? The foam keeps the surfaces in the attic well above the dew point at which condensation can occur, and the attic space is conditioned from below, so there is no worry about water vapor condensing at all.
Using closed cell foam in joist spaces also keeps water vapor out of the colder attic above because as a vapor barrier, no moisture can pass through it... so again no worries about condensed liquid water..
So regarding closed cell foams and water vapor issues, it is a win-win situation whichever place (joist or rafters) you choose to install.
But you should seriously rethink your use of foam altogether and in my professional opinion.
The best insulated homes use combinations of insulation types to deal with heat losses and gains from convection, radiation, conduction and air infiltration...and no single type of insulation, especially foam, can address all these insulating issues.
Here is a helpful "cold climate" home insulation design from the
Building Sciences Corporation that could easily be adapted for use in Minnesota:
http://www.buildingscience.com/desig...iles/aspen.htm