The Daniel Craig era has ruined James Bond, and he is the worst to play him just due to how he changed the character.
I don't mind a franchise modernizing, removing offensive tropes, and changing with the times. In fact, I'm in favor of removing all those aspects. They HAVE to be removed. However, you can still do this without fundamentally changing the character. Daniel Craig and the producers fundamentally changed the character of James Bond. You can remove the sexism and racism without transforming the character to have completely different basic motivations and emotional basis.
The film version of James Bond was always primarily motivated by pure self satisfaction and gratification, AND loyalty to the crown. Historically that was displayed with emotionless sex, using women, and the enjoyment of killing people, all while humoring himself with his silly jokes. He had never been motivated by healing personal emotional wounds (heck, he was immune to emotional wounds) or out of love for any individual with the exception of Felix. To properly modernize the character, James Bond should still be primarily motivated by self satisfaction and loyalty to the crown, but could be displayed by different things of what purely satisfies Bond. Killing in cold blood while enjoying it and joking to himself could stay. The Craig films however did away with all those motivations except for a few flash instances. He retired like 4 times (yes loyalty DID bring him back) but his primary motivations through much of Daniel Craigs arc was out of mourning or almost depression, not anything to do with pure gratification. Yes Bond had loved women before, but any love for a women or others was far far far down on the list of what motivated him through all the films. The Daniel Craig James Bond isn't really James Bond anymore, just in name. There is nothing wrong with Daniel Craig's character, it just is a different character than James Bond. One could make a different film with his character and just call him by a different name. Nobody is stopping such a film to be made if that's what the producers want to make. Just don't call him JAMES BOND.
Although not a great film, Pierce Brosnan's performance in Tomorrow Never Dies was perfectly in line with who James Bond IS. That was the single greatest performance of James Bond post Sean Connery. Heck I think Die Another Day is the worst James Bond film, but its STILL absolutely James Bond. Make a modern/more realistic/better scripted of that James Bond (without offensive tropes) and THAT would be great!
I think the next step going forward is for the next film to be a period piece. We don't NEED James Bond to exist in the 2020s for the films to be successful and relevant.