I agree with Judo Chop.
In his second innings, YOLT, his expression says, "Groan! When will this damn thing get over? Wish I'd never heard of James Bond!" His performance is comparable to Rodge in AVTAK (but Con is physically fit in YOLT) and he's at his nadir.
For his third innings, DAF, he has one eye on the big fat check he was offered. It's clear he was doing DAF for the money. But the three year rest did a bit of good, and his performance is only somewhat better than YOLT. Comparable to Rodge in Octopussy.
He looks healthier and happier in NSNA than he does in the above 2. His fourth inning is better than his second and third. He is playing Rodge in this movie, and his performance is like Rodge in FYEO.
I wonder around when did he get fed up of Bond.
And btw, does anyone have a pic of a bald Connery from his Bond days, preferably from the early 60s when he was at his peak? Would love to see him like that! 
I'm sorry but there's a huge lack of credibility when you use your 12 year old cousine sister who's only just started watching Bond films as a leitimate example to support your claim of Connery being a not so good Bond. First of all, James Bond is an institution, which your cousine probably isn't aware of. Secondly, Bond is a timeless character, whereas your cousine is a product of the cheap mtv generation, she'll have no concept of the traditional and social values that were upheld during certain decades, particularly the 60s era.
However, it does come down to a matter of taste.
Connery is the only James Bond actor that was able to carry a Bond movie by himself based on his screen presence alone and this was even when he was a relative unknown. More importantly, when watching Connery, you believed he was a spy/secret agent and this roughness people keep talking about is, a legitimate and credible characteristic when highlighting the attributes of a spy.
Lazenby was good for someone who had no real acting experience and although he excelled at the physical aspects of the role, he was able to bring an emotion of sensitivity that added a new layer of charcater to the character of Bond.
Roger Moore was quite frankly imo a clown. He had his moments as a good Bond but he was never great, never in the same league as Connery (no one is and probably never will be) and he just never sold to me or could convince me that he was a secret agent. Look at his fighting style, it was ridiculous, the Moore era is like, a carry-on version of the Bond series, I really have to be in the mood to actually watch it, let alone enjoy it.
Dalton was simply unfortunate. He was actually the closest to the character in the novels and imo did everything that Craig did in CR but went unappreciated. Worse yet, he was coming off the heels of Moore's clownish antics which audiences had become too used to. Thus, Dalton's interpretation was too drastic from the kiddified version and silliness of Moore's era.
Brosnan is simply overrated. Period. He brought nothing new to the character, had the worst and cheesiest dialogue and easily made the worst film of the series (DAD, yes, it's worse than DAF).
Ultimately, what Connery has over the other actors besides the obvious was, his sheer screen presense and charisma. His worst films, YOLT, DAF and NSNA are pretty much saved and more than tolerable primarily because of Connery's charisma.
