Yes, those first connery's are actually the only run that doesn't seem to have been interrupted by a bad bond film. After that however it seems quite hit or miss.
Yeah, it really is. In fact, the Bond series doesn't have two great back to back movies after Goldfinger and Thunderball.
There are still a few gems after like On Her Majesty's secret service, the Spy who loved me, For Your Eyes Only, and the two Dalton films, chiefly for his brilliant portrayal of Bond.
Dalton's films were okay. I liked The Living Daylights, and License to Kill is okay, but the problem with LtK for me is that it really lacks some of the fun factor of other Bond movies. It leaves me cold at times and there were times were I really wish Bond would say a Bond one liner, or if they would lighten the tone a little.
People say Dalton is similar to Craig, but Craig is more charming and has more charisma as Bond than Dalton had. I just think Dalton played the role a bit too seriously at times, which is understandable because Dalton is probably the closest to novel Bond of all the actors, but I always say the Bond's portrayal in the movies is best and should be a combination of the novels and movies.
You know, I think the cinematography during the Brosnan and Dalton eras were the least impressive of the Bond eras. It was especially dull in Tomorrow Never Dies. The Connery films shot by Ted Moore were beautifully glamorous. Freddie Young's work in You only Live Twice and Michael Reed's work in OHMSS are the gold standard. The Moore era also had decent to good stuff.
I'm glad the Craig films brought back cinematography to the early Bond levels. Even QoS, with it's choppy editing, has some spectacular wide shots. And of course, Skyfall looks to the best yet.
Don't forget about The Spy Who Loved Me. I feel like that was one of the best shot movies.
I agree about Brosnan and Dalton eras. Both of them just feel like generic looking of their eras. John Glen is not really a great director visually, and that's why a lot of those movies visually are not impressive. And while Goldeneye was okay visually, the others got worse. That's what happens when you use mediocre directors.
In terms of look and cinematography: here are my top 5:
1. You Only Live Twice
2. The Spy Who Loved Me
3. On Her Majesty's Secret Service
4. Thunderball
5. Casino Royale