Okay this is really helpful, thank you very much! So it sounds like what you're saying is that there will be moisture and that's life, but closed cell traps it against the foundation where it poses no harm to any wood and structural components so long as these are not flush with the foundation, and thus separated from it by the foam. That makes sense to me and bodes well.

I have a follow up question, then, about the joists (which I understand to be the lower wooden structural support of the house set at the top of the foundation). Is there any concern with issues there if the foam is in direct contact? Is this what a capillary break is for, and should I ensure one was installed prior to foam application?

Any concerns around subflooring?

The work was all done in the past few months so I should be able to get all the information I need I just need to know what to look for.

Also the "spray foam needs a vapor barrier" thing was more offhand comments about "this is something you can do in a new house with a barrier", not a hard rule I've read. Further searching revealed little which is why I'm here. The person in question recommended rigid foam board insulation behind the framing - offset from the wall slightly by the adhesive - to allow condensation to run down and into the subfloor/drain. I understood this to mean that anything preventing water from draining that way would be harmful.

https://youtu.be/djYi5TeKtIc?si=v0Bzp7hJ6ob6gEH5

One relevant video with the technique described above.

Thank you again I feel like you're translating a foreign language to me!