I'm not a native Canuckistani Code speaker, and I have a hard time even parsing...
"The installation of additional insulation will move the dew point to a colder portion of the assembly which will result in condensation of water vapour within the assembly"
...but it's an almost a nonsensical statement, that apparently misuses a commonly mis-used term.
The dew point is a TEMPERATURE, not a location.
The dew point doesn't "...move..." "...to a colder portion of the assembly..." It can't move- it's a function of the humidity of the body of air- it's the temperature at which the air is completely saturated, and removing more heat results in fog or dew formation before it's temperature can drop below that point. (Hence "dew point")
The dew point of the entrained air inside the rafter bay will track the temperature of the coldest surface that it's in contact with, which in this case would be the interior surface of the closed cell foam.
The relevant dew point for wintertime moisture accumulation in the assembly is the dew point of the interior conditioned space air. IIRC the National Building Code is predicated on a conditoined space average of 20C / 35% RH (a comfortable & healthy indoor humidity level) which has a dew point of about 4C. When conditioned space air comes into contact with a surface that is at 4C or colder, the moisture begins to condense onto (or adsorb into) that surface.
When the condensing surface is wooden roof deck, the moisture is adsorbed directly into the wood, raising it's moisture level. If that moisture level remains high enough long enough there is a risk of rot & mold.
When the condensing surface is closed cell foam, it condenses as liquid on the surface. If that surface is in direct contact with cellulose insulation, the cellulose wicks/adsorbs the moisture inside it's hollow fiber structures, redistributing it, and continues to insulate well, up until it is nearly saturated.
There is a finite amount of entrained air in the fiber insulation layer. As the temperature of the condensing varies over the course of day or winter season the average moisture in that air will vary with the amount of moisture that is condensing & re-evaporating. It's the AVERAGE temperature of the condensing surface that matters. As the average temp of the condensing surface drops below the dew point of the conditioned space air, the vapor pressure of the air in the fiber insulation drops, creating a vapor-pressure difference between the cavity-air and conditioned space air. When that happens water vapor will move via diffusion from the conditioned space into the cavity air.
The rate at which that moisture moves is a function of the vapor permeance of your vapor retarders (including the paint). If that vapor permeance is too high and the average temp at the surface of the closed cell foam is too high, it's possible for enough liquid moisture to get in there over the course of a winter to cause mold conditions, and that is what the inspector is (or should be) concerned about. The vapor permeance of the foam is low enough to protect the (even colder) roof deck, but since it's on the cold side of the fiber layer, it doesn't protect the fiber from moisture accumulation.
But that is why you want to have a "smart" vapor retarder. These materials are less than 1-perm @ 35%, which is about where you want to keep your conditioned space air in winter. When the condensing surface drops to 4C or below and condensing begins, the RH air inside the rafter bay right next to the smart vapor retarder drops below 35% RH, making it even more vapor-tight. The finish paint (about 3-5 perms) limits the rate at which the micro-gap of air between the membrane & gypsum rises. The colder it is outside, the lower the temperature of the condensing surface, and the lower the RH of the entrained air in the fiber, making the vapor retarder ever tighter. But when the roof deck temperatures rise (in spring, or a warmer than average winter day) the moisture is released into the fiber, raising the RH, opening the membrane's vapor retardency to release some of that moisture back to the conditioned space.
To do it without a vapor retarder, the average winter temp at the surface of the foam needs to be higher than 4C. The ratio of foam-R to fiber-R to make that happen is of course climate specific, but the notion that "... no additional fibrous insulation is allowed within the assembly on the warm side of the foam" is completely ridiculous, unless it's literally never warm enough for that surface to be above 4C over the course of an entire average year. (There are high-altitude locations in Antarctica where that might be the case, but not most places where humans actually live.) This has long been understood by code-drafters in Canada, if not by all local inspectors, which is why low permeance exterior foam is expressly allowed without interior vapor barriers, provided the R-value ratio is sufficient.
See:
https://www.nrc-cnrc.gc.ca/ctu-sc/files/doc/ctu-sc/ctu-n41_eng.pdf Our goal in your case is to provide a reasonable drying path for the roof deck, while severely limiting the amount of moisture that makes it into the fiber layers. The 2" shot of foam is sufficiently vapor open for releasing the miniscule amount of moisture that would accumulate in the roof deck over the winter, but insufficient R for accommodating a high-R fiber layer without enlisting a smart vapor retarder membrane. But those membranes DO work, and work pretty well. The places where smart vapor retarder would not work would be where the interior air is well above 35% RH much of the winter, say a hotel's pool & hot-tub facility or a sauna, steam bath, etc. Those situations aren't common in most houses, and where present those portions of the house would need special treatment on wall & roof stack-ups.
The primary vapor retarder in the stackup is the smart vapor retarder, even though the vapor retardency of the foam is important for protecting the roof deck from excessive moisture accumulation, but also for giving it a drying path. Both the accumulation rates and drying rates are important, but far more important for the roof deck than the fiber layers, especially if the fiber layer is cellulose, which can handle fairly substantial moisture loads without damage or loss of function.
It might also be useful to print out the Canadian short-sheet spec for MemBrain to present to the code enforcer, that notes in the fine print that it performs at less than 57ng/P·a·s·m (and thus ducking under the 60ng/P·a·s·m hurdle) using ASTM E96 dessicant method, while exceeding 572ng/P·a·s·m using water method, indicating just how fast it can dry should the assembly actually become wet:
http://www.certainteed.com/resources/30-26-074.pdf It looks like you can even buy the stuff at Lowes in Canada:
http://www.lowes.ca/radiant-barrier...68192.html