Of the four Pierce Brosnan Bond movies, the first one was great (Goldeneye, so good), the second one was decent (Tomorrow Never Dies actually has a lot of relevance today, as it's about the control of corporate media with misinformation, which is rather prescient for 1997), and the final two were bad.

Of the five Daniel Craig Bond movies, I differ a bit from the consensus. The consensus is that the first (Casino Royale) and third (Skyfall) were great, but that the second, Quantum of Solace, was the worst and the others were okay.

However, while I do think the first Craig movie (Casino Royale) was great, and Skyfall was the second best, I think Quantum of Solace as the second movie was underwhelming but not bad. It was kind of that middle-of-trilogy vibe. I rate it above the consensus. The true catastrophe of this series, which I rate below the consensus, was actually the fourth movie Spectre. Utterly awful in terms of plot, especially given Bond's greatest villain Blofeld played by Waltz, which is such a strong casting. They fucked the whole story up and it made no sense. Bond literally walked into the evil headquarters with no plan, and got captured. And then when the villain is drilling into his head to erase his memories, it just randomly didn't work, and he broke free via bad narrative. Made absolutely no sense. People were too accepting of it because they liked Waltz on screen and he distracts them from how weak his character was and how bad the plot was. And Blofeld was way too obsessive with Bond. Cool villains aren't as obsessive as that. And then the fifth one was solid and partially salvaged the catastrophe that was Spectre. Kind of mediocre like Quantum of Solace, but with a solid and surprising climax to the series, which elevated and completed it.