OB covered about everything I'd say.
But since when has THAT stopped me from writing?
YOLT:
I don't mind Connery in this, but I think that's more because so much of the action and concepts are cool in a way that strongly resonated to my 11-year-old self (which was how old I was when I first saw this one). The whole thing is incredibly over the top. Actually, it continues and expands upon a formula established with Thunderball (although you can see its origins in even Dr. No). Secret lairs, implausible gadgets, big commando raids, threats to WORLD PEACE ZOMG!!!!!!11!!one!
It does lack the punch of some of the earlier films, though, and Connery doesn't seem QUITE as...I dunno...energetic? Determined? It's not quite that he's phoning it in to me (that's more in DAF). I think part of it's that he's getting bored with the role, but part of it's the writing too. The films are, by now, becoming increasingly outlandish, and Connery no doubt recognized this.
OHMSS:
GREAT film. One of the closest to "literary Bond" and therefore one of my favs. Lazenby, I think, could have done a great job and gradually transitioned into his own Bond. The forced Connery aspect is unfortunate, but the rest is gold. And let's not forget Diana "Mrs. Peel" Rigg who seems a worthy mate for Bond, for once.
DAF:
Bleh. Jill St. John's hot, though. I'll give her that. For what it's worth, the book isn't that much better. It's campy in its own way, involving a goofy Anglicized version of American organized crime. Kinda like the "gangsters" you see in the film version of Goldfinger.
This film also heralds "The Dark Times" for Bond.
The Moore era on the whole is a VERY mixed bag. Far too much slapstick comedy and bad one-liners and sight gags. At the same time, it's set against some otherwise fairly dark moments or material. In a weird way, it's kind of like the imbalance in Indiana Jones and the Temple of Doom. One moment Willie's comically shrieking, another moment Mola Ram is ripping someone's still-beating heart from their chest. It's not quite as stark as all that, but there are aspects of it which can be. More on that later in the journey, though.