In fairness, that's not the movie's fault, and its inclusion adds a touch of realism. If you're at the Pyramids of Giza at night, that light show will be playing. That said, the whole Sound and Light Show (which is still playing today, with the same narration) is basically an hour-long Big Lipped Alligator Moment.
Crowning Music of Awesome: "Nobody Does It Better" is regarded as one of the best, if not the best, of the Bond themes—#67 on AFI's "Songs" List.
Ensemble Darkhorse: Jaws, who along with Oddjob is one of the most popular villain henchmen of all time. The guy became so popular that he's so far one of the only two James Bond villains that were allowed to return to a sequel, and when people hear Bond villain, he's likely the one that will be remembered first. It's probably the steel teeth.
Ho Yay / Worthy Opponent: M and General Gogol. After British and Soviet forces decide to work together, Gogol calls M "Miles", M calls Gogol "Alexis", and they act overly friendly to each other. Bond and Anya give a WTF look to each other after witnessing this scene.
Rooting for the Empire: Richard Kiel has recounted how Jaws' survival at the end was met with giant applause at several screenings. He might be a villain, but he's such a Determinator that after a while you sort of root for him.
So Cool It's Awesome; It's almost guaranteed to appear in "Top 10 Bond Films" lists, with a roughly 50/50 chance of it being rated higher than most of Connery's Bonds, sometimes even higher than Goldfinger. Quite a turnaround.