I understand where you’re coming from, friend, and I particularly agree with the first bit about this being like Dalton doing GE with Talisa Soto.
Unfortunately, Eon seem so relaxed about the longevity of their series that they seem to take its success for granted, as opposed to cultivating new generations so a future is more or less assured.
But, like SAF said, you need to think about your health. To be brutal for a moment, it’s just a film, and you’re still going to wake up the next day and brush your teeth. I’m a big Bond fan, but I’m getting to the other side of it now. We’re getting two films this decade (NOTD - 2021, Bond 26 circa 2027), and there’s nothing we can do to change that.
For the last few years, I decided to take stock of what I actually like about Bond - the adventure, the geo-political plots, action, humour - and find that in other things. And there’s so much of it out there, and if you haven’t looked than I would kindly encourage you to do so.
In books, there’s Clive Cussler, Robert Ludlum, Steve Berry, Scott Mariani, Simon Kernick and dozens of others; in films, Mission Impossible, John Wick, etc; TV, there’s 24, MacGuyver, Jack Ryan, Blood and Treasure, and old stuff like The Man from UNCLE, The Equalizer, Magnum P.I., The Saint, The Avengers, The Champions, Danger Man, Department S, The Protectors etc. In other words, Bond isn’t the only game in town - it wasn’t even so in the '60s - and I don’t treat it as such.
(Also, I write my own original fiction too, so I take what I like in Bond and others and reproduce it in my own way).
I hope you don’t continue to struggle with this NTTD thing in a big way. Keep everything in perspective and proportion.