I really can't recommend NC highly enough. It's diverse, sports a great mix of rural, suburban, and urban areas, is relatively cheap to live in, and has lots of activities.
Dunno about the movie business here. The Triangle area (Raleigh-Durham-Chapel Hill, where I live) is getting pretty decent for game development.