It will end up being someone lousy. The Bond franchise is like Star Trek films. You get good bond/lousy bond/good bond cycles over and over. They’ll go for someone pretty, it will flop after one or two movies, and then they’ll hire a good actor again.
I don’t really count Niven and I can’t explain the gap between Brosnan and Craig. Maybe it has something to do with switching on the superconducting supercollider. I’m also still disappointed Halle Berry as Jinx didn’t get a spin off movie.