Terminators, ALIENS and Titanic. He's also did Pirhanna 2 and True Lies, which aren't masterpieces. Avatar did well for 3 reasons, His first film in 12 years and since titanic, and 3D.
I don't think Avatar was bad, it was very device when it came out, but it was 19th all time in ticket sales...