Gene Hackman and his wife Betsy's two dogs led paramedics to the actor's body in a final act of loyalty, after the couple were found dead in their Santa Fe home two weeks ago