Diamonds Are Forever won’t stick in your memory forever, but it’ll occupy two hours and give you a bit of a callback to the better bits of Connery as Bond, even if it doesn’t reach the potential peak.
There is an argument that the song Live And Let Die by Paul McCartney and The Wings is the greatest Bond theme song ever, but you can’t make that case for the movie.