Connery was best. Timothy Dalton a close second.
Timothy Dalton would have been a great Bond if he was in better versions. He was caught up in the 80’s Bond doldrums.
From a cinematic viewpoint, for me its Connery, Dalton, & Craig.
Worst was Roger Moore, I think it was the writing, all his Bond movies were camp. He was certainly “cool” enough, after all he was “The Saint”! ,