Interesting discussion!
My problem is a little different but might be informative. On the trip in early July we had a heavy rain and water dripped on the cabover bed, right on me. I woke up in the middle of the night wondering if was the dreaded incontinence. The drip was out of the ceiling seam, open for inspection in this view. I can't see very well in there without damaging the sheet of ceiling material and I don't know what kind it is or where to get it.
I put planks under the wheels on one side to help the water drain off the flat roof and turned off the fridge for the rest of the night. At home I took all the caulking off the ceiling vent and noticed the metal roof sheeting goes right up to the plastic trim, looking like leaking water could not escape into the ceiling. Next move was to redo the caulking along the join between the metal roof and the plastic front of the cabover.

That looks a little messy but it seems to have worked. No leaks in several rains. Note the piece of 2 inch wide eternabond over the caulking on the far end. It stayed there for weeks and 1000 km of driving. I think I will run 4 inch wide eternabond over the whole 8 foot joint.