I give him credit as being a good technical director. Someone you would want to be in charge of special effects. However, I can't stand James Cameron's movies. The reason is that he is a horrible screenwriter. I seriously bought Rambo: First Blood Part Two, because it is the most hilarious unintentionally comedy ever. It was written by Sylvester Stallone & James Cameron. I even think Aliens is the worst sequel in the Alien series. That is saying a lot considering what a hot mess the other Alien sequels are. At least, the other sequels wasn't mired in tired tropes and cliched storylines.Gordon_4 said:Lot of fine choices here, so I'll throw a more mainstream entry in: James Cameron.
I know, the guy that made Titanic and Avatar? What are you smoking you silly engine? Well, I realised that basically every movie James Cameron has ever made is eminently watchable. Not all are transcendent classics like Raging Bull or Platoon but everything is solid across the board. His peak output is probably The Terminator series, Aliens and Titanic but True Lies, the Abyss, and Avatar are all totally watchable, fun movies.
Note, this does not excuse his shitty personal behaviour: seriously he nearly killed Ed Harris, his falling out with wife Linda Hamilton is a matter of public record and in a bout of beautiful poetic justice, she held onto the rights to the Terminator franchise for a long while. He's mellowed as he's aged, but he's still a bit of a knob. Mind you, if you could work for him you could probably work for anyone.
Long story, short: I think James Cameron and his movies are massively overrated.