I'm not sure if I agree, tbh. You've certainly brought up some good cases of failures, but what about:
Tesla in Sparks NV, BMW in Greer SC, or Mercedes in Alabama and SC? It seems like those have more than paid for themselves by now. In at least one of those cases, they've had huge regional impacts.