He seemed like a classy guy. He made the decision to stop playing Bond because he said the leading ladies were young enough to be his granddaughter, and "it was disgusting."
Connery's Bond was also awfully sexists and misogynistic. It's incredibly cringe trying to watch certain scenes of that era. Some are rape fantasies through and thru.
The first book is interesting... it has the typical Bond setup... here's your mission, your exotic location, and your beautiful assistant... and Bond goes:
"A woman? What are you sending a woman for, she'll only get in the way."
License to Kill was a bit before its time. Bourne before Bourne was a thing. I think people still wanted the campy Moore era and just weren't ready for that.
Casino Royale aped the Bourne thing later and was a smash hit.
He was much better as a supermarché owner in any case.
I don’t think Lazenby gets enough credit but yeah I’d agree. Dalton is also the best actor outside of Bond, Connery probably has more credits but he’s not a time lord.