Regarding Bond, a couple thoughts. Disclaimer, my first Bond was Moore, though I cannot recall which one of his it was, but I saw a few before I saw a Connery Bond, which my mom (a huge Connery and Moore Bond fan) said I just HAD to see.
I think Connery became a much better actor as he got older. He never really captivated me in a performance till The Untouchables. He was stellar in The Last Crusade.
Connery's Bond films seem to spend a lot of time with Bond kinda stumbles around, gets captured, escapes through some combination of luck and bad guy ineptitude, sleeps with someone, and then beats the antagonist who had a ridiculous scheme that shouldn't ever work in the first place. There just isn't a lot of espionage and spying going on. That isn't to say they aren't fun movies though, because they are.
Moore's films keep the basic formula but give the franchise a much-needed kick of adrenaline and drama.
I cannot comment on the Dalton films, I don't know them well enough.
Brosnan was great as Bond and Goldeneye was the perfect film to bring the franchise to a new generation. Then his films got a little silly. They were still fun, and he delivered all the silly lines and wore the tux well.
I wasn't there in real time, but I cannot believe the first couple Bonds were viewed as solid enough to build a half-century spanning, 25 film franchise upon.