In my mind, the franchise ended at Casino Royale, a fitting end. Quantum of Solace, Skyfall and Spectre were Bourne clones skinsuiting as Bond. You could tell the right people hated Bond eventually because No Time to Die was them just gutting Bond as much as they could but also had to acknowledge the franchise was popular enough not to outright kill it off.
The Bond franchise really can’t continue though because today’s villains are also society’s heroes. The megalomaniacs of today are today’s benevolent billionaire class, soyentists who fuck around with viruses in government labs, and NGO leaders like Soros or Schwab. Never has there been a better potential era for Bond than now but we’re told to worship these people, not stop them. So all Bond can really do is stop a clone of Putler or stop a small band of white supreeeeemists from hurting pee oh cees. The villain cannnot even be North Koreans anymore. At this point it’s better to just end the franchise than make some awful Bond flick where he’s going to stop the Proud Boys.