What is causing my foundation wall to sweat?
...crawlspaces properly, that may help you get a better idea of the physics at play with basements and water infiltration.
The general contractors you spoke with would have the advantage of having seen it, though I would expect that foam on its own may not solve the problem. I would suggest some sort of waterproofing mem...