I rewatched it last week, and I while I still liked it, I also still have the same problems with it. It’s a beautifully shot movie, and I like the themes that are introduced early on - Bond as the old war horse who is getting tired of the job, and his relationship with M turning out to be more twisted than we thought and M herself far more ruthless.
But these themes are never really dealt with in the rest of the movie; instead, it becomes about new tech vs. good old spying. And it all completely falls apart when they go to the old farmhouse and team up with the trusty old gamekeeper - that’s when it just becomes silly. That’s also when the last and suddenly most important theme is introduced into the movie: nostalgia for Old Bond. It starts with the old car and its gimmicks (that don’t work in the context of the new Bond movies), and then the ending shows that actually Skyfall’s agenda was entirely reactionary all along: the competent female agent whom we met at the start of the film is banished behind the desk and turns out to be the new Moneypenny whose main job will be flirting with Bond, and M is once again a man. Welcome to the seventies.
And that’s what Spectre continued - it had a 70s era plot, which is why it didn’t work at all.
In contrast though, I also tried to watch Tomorrow Never Dies which I remembered as nothing spectacular, but entertaining enough when I saw it back then and it was bloody terrible. Gave up after half an hour or so. And then, once again in contrast, I finally saw Quantum of Solace, which wasn’t much liked back then and I have to say it was completely fine. I think a lot of the disappointment had more to do with how exceptional Casino Royale was; Quantum of Solace was just a Bond movie, but a pretty good one, I thought. And interestingly, it gave Bond a tiny bit of a soul and maybe even the ability to love.