I wouldn't say any movie mentioned here is overrated, if you're counting the ratings of professional critics. Movie critics AREN'T game reviewers, and don't need to "maintain good industry relations" and give high-scores left and right. I trust them more than I trust any videogame publication.
For example, I didn't relate to The Dark Knight. Fun movie, nice villain, boring protagonist, some melodrama, complex plot, fantastic direction, yadda yadda, the theme and feel doesn't concern me. But it was rated highly mostly by AMERICAN critics that understand the appeal. To me, it was something distant, trivial and alien. It had no weight because I wasn't part of the culture it was focused on. It could not affect me.
On all other counts, it's superb. But it still made 55% of its box office in America, and the world just didn't get it. That doesn't make it overrated.
Avatar is another example where people use "overrated" when they simply didn't like it. If you look up what the average movie critic praised it for, it's spectacle. Avatar is an spellbinding, emotionally manipulative thrill ride. It's big, cheerful, universal, familiar and simple on every level. The equivalent of a crowd cheering for its team at a sports game, or an orator riling up his audience. The critics that praised it compared it to Star Wars and Jurassic Park for its ability to incite childish glee. Plus, the research and effort that went into making it believable and detailed is just astounding.
There is nothing wrong with expecting something else from movies, but saying the critics rated it wrong, when in fact they rated it for what it is, is narrow-minded. Like saying "rollercoasters are sooooo passé, I mean where's the layered narrative in them?", thereby completely missing the point of why people board a rollercoaster.