I always thought “Dr. No” was the best of all the Bond films. It was also by far the closest to the book in fact some of the dialogue was taken word for word from the book.
The next few didn’t stray too far from the books but the last twenty or so have had no connection at all to them. They also have all been awful. More cartoons than real stories.
The second one, From Russia with love has always been my favorite. The first four movies (including Goldfinger and Thunderball) were all reasonably close to the books. Although the gimmicks started taking over in Goldfinger, after You only live twice, it was all over.
Just as the original Sherlock Holmes stories were re-made with Jeremy Brett in the 1980's, I've always thought that someone should re-make the original Bond novels. He was more like a real person in the books and you can trace his physical and mental deterioration in the books.