Just thinking of music tied with the shot, the ending to Full Metal Jacket is quite memorable and sums up the themes of the movie quite well.
However, I tend to disagree with the premise since there are great movies without memorable endings and bad movies with memorable endings (and everything in between).