On jobs, I’m unconvinced that stadiums create many jobs. At least at the stadiums I’ve lived near, they seemed to be fully staffed with far fewer people than other social venues - say casinos (though I don’t see a US government making a casino) or even a mall.
I’d rather localities invest in community centers, libraries, museums, etc than stadiums.
There will be a lot of jobs during construction, but it's perhaps worth noting that those will not necessarily be for locals. In operation, I agree that thr number of jobs is likely fairly low, and mostly low wage.
Those construction jobs are invalid for inclusion because they’re temporary unless the building is going to be destroyed and rebuilt regularly. The only jobs created that can be included in the decision to build or not are the long term jobs.
I’d rather localities invest in community centers, libraries, museums, etc than stadiums.