MOST of the bad reviews on a lot of the Connery era 007 movies are... political. They don't like classic 60s 007 because of contemporary Woke six decades later politics.
But.... this one just sucks. And, keep in mind, I say this with Connery being my favorite 007 and 4 out of his 5 (6 should NOT be counted) outings are my favorite 007 films.
However, this is Connery playing a goofy Roger Moore era 007 and that doesn't work. This is Connery in a film that had all the coming Moore tropes. And that doesn't work.
Had Diamonds are Forever been a Roger Moore 007, it wouldn't have been that bad. This was Moore's Bond film... only it had Connery in it, so it just didn't work.