Is the use of tax dollars by cities attempting to attract and retain professional sport franchises a good thing to do?

It has been debated for decades. There are drawbacks but in the end the existence of pro sports teams does generate money in their host cities. It would seem to be a net positive.