PEOPLE: This novelist made a music video of his own song "The Madison County Waltz"; his wife played Francesca in it