I liked Roger Moore, didn't take himself too seriously but his Bond movies were like Our man Flint. Pure spoofery, especially towards the end.
I've never watched a Bond film but when I picture James Bond in my head the one I think of is Brosnan. No idea if he was any good as Bond or not, don't care really **** up.
David Niven was great in everything he was in. Guns of Navarone and A matter of life and death are particularly good. Casino Royale, not so much. Woody Allen ****ed it tbh.