So reading through the links doitmyself (and I do appreciate the research) the first link is for housing structures and the adhesive refers to existing sill foundation walls. Also at the top of the article under exceptions it lists this: Buildings with a lateral force-resisting system using poles or columns embedded in the ground. This building has several knee braces for the walls and the roof.
From what I read mechanical fasteners are not allowed in seismic areas, like where Tahoe hybrid is located, or in Virginia. Like I said in another post I'll order some brackets and do some testing.
From my original question, which the discussion has deviated a bit, I still don't think the screw type anchoring system will fail any differently (hopefully never fail at all) in a pier vs a poured wall foundation, which is the typical application for these screw type brackets.