I'll go back to Michael Wilson's quote "We always try to make From Russia with Love and we always end up making Thunderball."
Goldeneye was the most balanced movie that Brosnan got to make. TWINE is this "serious" Bond movie interspersed with BIG ACTION SCENES. TND is like this to a lesser extent but it never has the weight that the "spy" scenes in TWINE have. TBH both Carver and Renard are better on paper. ("They'll print anything these days.") Two actors who should have been the best Bond villains ever. Maybe my expectations were too high.
(You want to see Robert Carlyle be Bond villain? Watch Once Upon a Time.)
Then DAD comes along. Rather than flipping back and forth they have the "serious" (<- I can't not put that in quotes) part of the story almost entirely up front. Then you get to the ice palace and it becomes a very action packed Roger Moore film. It's the silliest film Brosnan made. But almost only in the back half.
At the end of the day Renard isn't the villain, he's effectively a henchman, but yes he should have been better (see also Waltz).
I don't disagree with you but given the choice I'd watch TND over TWINE any day simply because it's more fun
