The story lines became more believable with Daniel Craig. He probably wouldn’t agree to get in a spacesuit or fight a 7’ tall guy with metal teeth.
Dalton was the worse one imo, I can’t remember even one of his Bond movies, or any of his movies for that matter.