My list:

6. Pierce Brosnan (he's a fine choice, but his films are lacklustre).

5. George Lazenby.

4. Roger Moore (I agree with him being more brutal than people give him credit for, by the way, especially that bit in For Your Eyes Only when he kicks the assassin trapped in his car off the cliff).

3. Timothy Dalton (massively underrated, probably closest to Bond as written in the novels).

2. Daniel Craig (for Casino Royale alone, but No Time to Die was unforgivable for the ending).

1. Sean Connery (no explanation required).