Is the Thompson's or whatever stuff you can get at HD/Lowes good enough or do I need to have the contractor bring some "good stuff"...?
"Good enough" is a relative term. I've had much better luck with Sikkens than anything else. It's not cheap, but it's held up well in both CO with our weather here, as well as on the waterfront boat dock in FL.