The stadiums generally are a bad deal for tax payers. They don't create jobs, unless you're referring to the temporary construction jobs until the project is finished (Selling popcorn seasonally isn't a real job).
NFL stadiums are the worst because if a team doesn't use the stadium for home playoff games its used 10 times (8 regular & 2 preseason games) for its intended purpose and MAYBE 5 more times for concerts. A lot of public money being spent to use the venue for 13 events a year.
How many local economies collapse when a sports team leaves? There are examples (Cleveland Browns, LA with the Rams and Raiders,now St.Louis, or Seattle with the NBA) and the cities do fine post team.
Im a sports fan and Id be devastated if my team left, but the stadium is hardly ever a good deal for the tax payers.