Two would be overkill, and so is active ventilation in the cavities.
Spray foam works great, long as you do get complete adhesion and coverage of the panels and the temp range supports proper curing so you don't get excessive off gassing lofter, some people are very sensitive to the fumes.
With rigid foam panels, making sure all metal is otherwise covered, and then a 'reasonable attempt' at stopping any airflows between the living space and the bodywork, that should be fine.
Not getting it perfect will allow any condensation to evaporate when you really heat things up.
The real key is ventilation, no way around it, you need a lot all the time bodies are breathing and sweating in the enclosed space. MaxxAir, Fantastic Fan plus an intake opening at the other end, pretty much 24*7 year round.
And avoid adding more than needed, open up while booking, don't use unvented propane for heat etc.
More extreme measures would only be needed if staying put in humid tropics or places like the PNW.