I have friends who work in film and have heard about the way the productions play fast and loose with "local hires" that then get reported as jobs created.

But setting aside all of that research shows little to no impact https://www.nber.org/papers/w25963 https://papers.ssrn.com/sol3/papers.cfm?abstract_id=3155407

The prestige of films being made in their state keep the subsidies rolling in but there are many great "bang for your buck" subsidies states could be making that just aren't sexy.