XR250, I see this sort of thing all the time, as I'm sure that you do too. By this sort of thing, I don't mean this exact application for a failed CMU basement wall, but I just mean a quick and dirty hand sketch lacking a lot of detail, and including some questionable info.
For this particular detail:
I don't have a gut feeling for whether or not the 6x6 wood posts will be strong enough. I would have to run the numbers.
The Simpson post base... GEEZ... you're right, it's a joke. Like you said, it is a proprietary product that has no tested or rated capacity in shear, so it's worthless in this application. What has the world of engineering and construction come to? A couple of decades ago, probably without thinking twice about it, an engineer would have maybe spec'd a couple of 4x4x1/4" clip angles (1 each side of the post) with a through bolt, and of course with each anchored to the floor. That engineer may or may not have then run some numbers to verify the solution would work, and maybe to figure the max spacing for the capacity of the connection, etc. Now days, it has to be a piece of light gauge crap. Why? Because if it can't be had at Home Depot, then it just can't be had, at least not by the numb nuts that are doing construction these days. My dad was an accountant, but he could have built this in his sleep, and he would have known the local metal shop where he could get the steel clip angles cut and punched any way he wanted them. Now days, if you ask a builder to use something he can't get at Home Depot, you might as well be asking him to launch a rocket to the moon.
Moving on, you gotta love the generic 5/8" anchor bolt. I guess any type and any length will do.
The top connection leaves a lot to be desired. I won't get into it.
Can you fault the engineer? I would say yes, a little bit, because there is minimum standard of competence and quality of deliverable that should be non-negotiable. But, on the other hand, you probably shouldn't expect much more or better for less than a handful of Benjamins, which is probably the fee that was collected for this feeble effort.