Oh boy, if they're making you watch Bond films wait until you get to "Live and Let Die (1960)". 😬 Bond being a chauvinist is kind of his thing, Flemming's novels are rife with it (as you note) since that was the whole thing. You're not going to like Quantum and I think Spectre is fine but it's a
Dench swan song film (she retired the role with that one, and it's impact only works if you ignore reboot Bond and come from GoldenEye forward). I haven't gotten to No Time yet since it's not widely available on Streaming I use.
No wait, Skyfall is Dench's last film. That's the one that is ok (but pretty bad plot) if you rode "M"/Dench's role from Goldeneye up to it. Spectre has some pretty good scenes but is kind of weak of a spy film. I remember the day of the dead scene and the skyscaper tower sniping as pretty ok.