I've never been completely against David Arnold - he's certainly kept the "Bond style" going even if I don't think he's quite got the hang of action cues - but I doubt that even he would consider his Bond scores to be superior to John Barry at his best (He called Barry "the guvnor", which suggests a certain reverence.) Barry set the standard for others to follow, and, imho, I don't think they have quite matched the classic 60s scores. Indeed, I don't think Barry's later scores quite matched his earlier Bond work, but that is just my personal view.
Although I am somewhat bored of his scores, I do feel like his soundtracks were sometimes suporior to John Barry...
As for an emotional Bond theme, I can't help thinking of "We Have All The Time In the World". Not just the Louis Armstrong vocal version, but the orchestral played when Bond proposes marriage, and again at the end of OHMSS as Bond becomes a widower only an hour or so after becoming a husband. I do like "Vesper's theme" and the way it is used in CR and QoS, but Barry's emotive and tragic love theme for OHMSS gets the nod from me.
Great points Guy. David Arnold does not have the finesse of John Barry, and he has never been in the same class. He derives his scores heavily from John Barry's as it is. He is John Barry-lite, with a lesser classical understanding of the orchestra. As a musician myself I find his sound often has that clear residue of having all been written on the same midi keyboard. He does a great job with it, I am not just knocking him, but it is evident in the composition and is NOT near as bold, fluent or classy as Barry's pieces generally were.

