I don't get the fuss about the Skyfall theme. I'll admit I'm not a big lover of Adele anyway but she sounds like she's asleep or been drugged while she's singing,
Live and let die possibly has the most bombastic track, but Macca's singing is pretty feeble, which lets it down IMO.
Goldfinger I reckon is the nearest in terms of both music track and vocals.
PS I was a big fan of a-ha in my yoof but will happily admit The Living Daylights is shite. I don't think there was a meeting of minds there. If There Was A Man by The Pretenders on the same soundtrack was better.