Roger Moore provided live-action cartoons, women became equal partners, and the series never recovered. Then the Fleming originals ran out, and now it's the same Hollywood that produces CGI stunts and thinks they are special effects.
Connery was anti-gun, an enemy of the right to keep and bear arms. He was an actor, not a champion of freedom.
I’ll leave others to discuss his misogyny and the celebration of an exploitive sexual lifestyle his Bond character typified.