But which state/county would be the winners? I see potential for spite-based decisions. I could see someone in NYC getting mad at his local city and redirecting their taxes to Hazzard County Kentucky for no other reason than it looked cool in the TV show.
[A very long time ago I ordered some custom arrows online and they were assembled in Hazard Kentucky, a city in Perry County.]
There's a lot of variables here. Appeal to out of states, distribution of in-state resentment.
Pretty much every city that drags its state around politically is resented internally and the real volume of political will comes from the "greater X area" but some cities are hated by their own populace (NYC comes to mind) whereas some aren't (Boston seems less hated IMO).
I think states like Tennessee and Vermont that aren't too resented internally but have a lot of tourism exposure would benefit.
So I think you've got to greatly consider the relative degrees and sizes of all the different effects.
And this is before you even discuss states gaming the system.
It's not all of the taxes, just a small part, and it's perfectly fine for a NYC dweller to do that.