Amazon paid no federal taxes last year (https://www.washingtonpost.com/us-policy/2019/02/16/amazon-p...), and probably would have figured out how to pay little corporate state tax. At the promised level of 25,000 jobs with an average $150,000 salary, the city (but not the state) would have only seen an extra ~$150mil in income taxes.
There's lots of ways to run the projections and factor various costs/benefits, but few of them would have resulted in a 10x improvement in the offhand estimates.
It was a bad investment for the city the same way most sports stadiums are.
https://www.cnn.com/2019/02/08/politics/amazon-backlash-alex...
Aren't the workers primarily knowledge workers? In a place like New York where developer jobs grow out of the concrete I don't think there could be legitimate fear of unionization.
Interesting that you characterize the entire state as "locals" given that some parts of New York can take several hours to get to by car from the city.