Both of his most famous movies were helmed by James Cameron, who directed Michael again in the 1989 sci-fi thriller The Abyss, featuring him alongside Ed Harris