Efforts are being made to lure prestigious, big-budget productions - and the jobs, tourism and economic spinoffs they bring