Gene Hackman, a Hollywood giant and two-time Oscar winner, was found dead along with his wife and dog in their New Mexico home Wednesday, though investigators believe they may have been dead for some time and the cause of death has yet to be revealed