Brosnan and Connery had good humor or could deliver a witty retort or puch line. Dalton and Craig more ruthless IMO, maybe closer to the books.
However, since Fleming preferred Niven he muse have liked some wit and a twinkle in the eye. Very suave.
Fleming wanted someone that looked like himself.
Also, would have been a truer fit to the role, having been a Lt. Col. in the British Commandoes during WWII.