Well, there are movies that I personally don't feel a need to revisit such as Titanic but I can understand why some people adore them.
A movie that I don't unreservedly love and which I can't understand how people think is forever awesome? Mmmm, <looks at
http://www.imdb.com/chart/top for inspiration> I'll suggest, given the way the sequels in part betray what it aspired to, that The Matrix somewhat qualifies though I did very much enjoy it.
Other movies that while also AAA Excellent still might be overhyped:
Million Dollar Baby: Great movie with amazing acting but a film for the ages ..... not.
Sin City - An amazing achievment of form and with compelling storylines and a unique style that helps set a wickedly delightful and noirish mood but did it distinguish itself to the level of other masterpieces that help define a genre or probe the boundaries thereof? Hmmmm ..... I'm reserving my opinion for the moment.
Blade Runner: One of my personal favorites and a movie I've seen and thought about countless times ........ but parts of it could have been done better and the movie as a whole leaves one with the feeling that you've just viewed a workprint of a film that has an amazing potential to occupy a unique place of honor in the pantheon of humanity's best films.
Like many of Dick's characters in the book the movie is based on and elsewhere, it's a bit broken. In a counterintuitive and unintended way that does add to the movies charm I guess.
Annie Hall: Perhaps too much a product of its time.
High Noon: Of late it seems mocking in how its theme doesn't really resonate with our existent culture. Does it speak to the principled individual within us all anymore?
On second thought maybe this movie is now greater than it ever was if it functions as a haunting reminder of an archtype that is seemingly lost to us.
Star Wars: Episode IV: Still great but for a slightly different list of reasons than it had originally. Suffers from a malady similar to that of the Matrix. But it differs in that it's disappointing prequels at issue here and to a lesser degree as it originally existed in harmony within an excellent trilogy.
The Godfather: A tad too hamfisted.
Fight Club: Please, unpleasantness can serve a purpose, it shouldn't be a cinematic religion. A mostly brilliant film though.
Pulp Fiction: Ground breaking at the time and worthy of all its awards and praise. We've changed, movies don't and the test of time imposes different standards.
Eh, I'm letting my current mood guide my fingers. The opinions above should be taken as possibly being of a transient nature.