It's weird because I feel like I just posted similar about someone else a few weeks ago (can't remember who), but Cameron seems to get a lot of credit for a really limited run of success like he's some amazing director.
But it's basically two Terminator movies, Abyss, and Aliens which was a sequel. True Lies was an amusing movie that I enjoy because I was a kid when it came out, but I'm not sure it's anything deserving of the type of praise Cameron gets. And I can't speak to Titanic since I've never seen it.
After that? It's literally just the Avatar movies, and they're terrible. Sure, I guess you can say he had some kind of vision that pushed CGI, but the movies themselves are kind of shit.