Best intro is hard to say, but imo the Jack White/Alicia Keys song was on of the weakest. It had no Bond vibe at all. Adele's was way better, and now Sam Smith's isn't that bad either. Goldeneye from Tina Turner has special place in my heart, but then again it was the first Bond I ever saw in cinema.
SPOILER BELOW:
Watched the film yesterday, am unsure about it. Plot feels like a patch-work, sub plots and places have no meaning for the film's progression, certain persons just end up absent from the film. I mean what happened to Belluci's character after James went to that secret meeting? What was the purpose of that drill machine used on Bond, why did Franz have it in the first place, had the operation on Bond's brain any effect at all. Was that stations purpose just to be blown up by Bond? Why was it out there in the desert?
And, while I normally like homages and retrospectives, this film was so full of it that it made parts of the plot too predictable.
Oh, he calls himself Blofeld and gets blown up? He will show up again, with a scar on his face... é voilà, there he is with a scar on his face.
Bond and the girl talking on the train? Hey it looks like in that old Bond before Jaws turns up. And there he is, modern Jaws-interpretation henchman.
Good parts of the film were the active roles of M, Moneypenny and Q, the car chase through Rome (that Jaaaag..), the seamless Mexico sequence, the Mr White meet.
-------
Imo Casino, Skyfall and Quantum were better films. But Spectre was still better than half of those Brosnan did.