I'm curious what you mean by "foamie"... if it's the XPS with PMF covering I'd strongly advise against that. Nidacore has poor thermal performance, but it's structurally good. You might check out CarbonCore, they have clone that is much cheaper. BTW, I'm building a camper out of PVC foam and hand laid fiberglass.
If your skins and joints and core are substantial, you really have a monocoque structure that is very strong. The cabover is more like a short box beam (very rigid and strong) than a cantilevered panel with weight piled on it.
The only place where you need to be careful is where the bottom of the cabover meets the rest of the camper. When loaded that panel will be pushing against a vertical wall that doesn't have lateral support so you'll get some high stress in that area. If you beef up that spot you should be fine.
On mine the floor of the cabover extends into the rest of the camper 20", and will be well attached to the side walls, so the load is already spread out quite a bit. I'll also have a generous radius and extra layers where that panel meets the front wall.