In a franchise picture serial, most of the time the first actor who plays the role sets a kind of standard, realistic or not and everyone else has to measure up.
Connery was great, but I also liked Timothy Dalton, who I thought was more ruthless in the role. Desmond Wilkinson, who played Q agreed and he also like George Lanzaby.
I also like Daniel Craig who brings and edginess to the role more like the character in the book.
To show you how petty and set in my ways I am the only Bond movie I saw after Connery left the role was “Live and Let Die”......pathetic uh?.....lol