The same is true for the Olympics, which is one of the reasons some people have called for a permanent home for them instead of a constant stream of white elephants
There is bound to be some local impact; even branded items bring in sales tax. But it is almost certainly not worth it on balance.