From The Color Purple to The Big Chill to Steel Magnolias to Deliverance, the South has served as backdrop for dozens of Academy Award-nominated films