What the Bond franchise needs is the right actor - but also, decent script, and decent Director. In 60yrs, still hasn't quite got there.
I can't abide Sam Mendes direction in anything - and so for me his twee/ sentimental approach killed the Craig era. Ghastly - but it had been dealt an early blow already by the studio strikes that ruined Quantum of Solace. I still think there was a very good sequel to Casino Royale, hiding in there in plain sight - but ruined by exigent pressures.
Timothy Dalton got the Fleming intent of 'ruthless to slightly cruel, callous playboy' right-on - but with tacky script suiting the era, and poor production.
The first, Dr. No, Connery's first outing - met the intent of the book. Playing 'patience' while calming waiting to assassinate the guy at home. Chandler-esque, but charming*. A product of its age for sure - prob my fave.
Roger Moore (perfect name of a 'Bond') - well: early Seventies camp. Quite brilliant at it, and of course Goldfinger is the Christmas afternoon film - file under 'guilty-pleasure.'
No suggestions or even requests for 'who next' - frankly, at this late age: the franchise is done.
* & cleverly referenced in the pre-roll of 2006 Casino Royale. There's lot went right with that one