I don't think the comparison to sports stadiums fit here. Usually there is already a stadium for a large NFL team or whatever in the city and the economies in the cities that are large enough to even host these teams are WAY more dynamic than where many factories are being built in the south or midwest.
For example Walmart's HQ was built in a TINY SW Arkansas town. The billions that have been invested there by the company, not only in jobs, but amenities in the city have no comparison to any other option that was available to them. If the city and state wanted to hand Walmart a $100 million dollar check, then that investment would have paid off way more than 10x. (IDK what subsidies they were given, probably none just using this for sake of the argument)
I know WM is the evil empire and I'm not defending all they do, just saying that if the right business moves into your small community it can be worth tens, hundreds or even many billions of dollars to a community that has no other options.
Amazon moving into NYC, or Atlanta giving many millions in subsidies to the Braves for a new stadium? Not really comparable.