Terminator 2 was the last Cameron film I liked. True Lies has some great action sequences but I found the racial stereotypes and misogyny a little distasteful.
Cameron always told very simple, basic stories with very stereotypical characters but he was fantastic at creating tension and suspense. He was also brilliant and innovative with action scenes. His early films all move at good pace, real thrill rides.
In latter years his films have got longer and longer with less and less action. For me the characters and story in Avatar and Titanic just aren't interesting enough to keep me invested. Both films just bore me to tears. I know i'm in the minority and both are hugely popular but I'll never be able to understand why.