I love Connery but some people hold him in way too high of a pedistal. Sure he was the best Bond but half his films were ****.
Sure Goldfinger and From Russia With Love are the gold standards of what James Bond is. Dr. No was damn good too. But Thunderball was the beginning of Bond becoming a characture. That is why he was bored out of his mind in YOLT which is where the campy Bond movies started, not Roger Moore. YOu could see Connery wasn't even trying in that one (much like Brosnan in the second half of DAD, I prefer both over Moore but at least it can be said Moore never let his boredom if there was any be reflected on the screen).
Then he got paid a huge pile of money to do DAF which is imo the worst movie in the entire series and again Connery wasn't trying. Moore for his part at least did some good htings with campy Bond (most notably TSWLM) and could play a serious Bond if the script called for it (FYEO). Connery only came back because Sony was desperate to make the Thunderball remake and again he was paid a huge amount of money to play Bond again. Now I think he is the best Bond but again his boredom in that movie is present, probably because he hated the producer and Kirchner (who was fresh off of Empire Strikes Back....go figure!).