Further it's worth looking at LA and the NFL. The NFL takes advantage of governments -- usually desperate governments -- to build their stadiums for them, and when LA didn't play ball the NFL went sulking out of town. Eventually they went back, paying for the stadium and all ancillary costs, out of their own pockets, with zero incentives. Because in the end it simply makes sense.
> Opposition that Long Island City doesn't want to be Manhattan, for instance.
Being converted in a residential area for rich people does not look better.
> there was opposition right at the very outset. Significant opposition.
Considering the level of misinformation and how politically entrenched it was this means less than usual.
I see you are not familiar at all where Amazon HQ2 was going to go. (Not NYC.)