If I had to pick another Connery, I would be hard pressed between Goldfinger and Dr. No. As it is, I can just pick From Russia with Love and be done with it.
Brosnan's best movie, or the best movie with Brosnan? As a Gen X'er, I think Brosnan was perfectly suited to my generation's Bond. GoldenEye is my favourite Bond movie of all time... I was totally pumped to see Tomorrow Never Dies on opening night... and I just couldn't get past how uninspiringly over the top it was. It felt, to me, souless. And it seemed to only go downhill from there. It was just too smug... too self aware, maybe. Too rote and too cliche.
Martin Campbell seems to do Bond right by me, since I didn't care for any Bonds after his GoldenEye until his Casino Royale (I really thought I was done with the franchise until someone made me watch Casino Royale). My wife even loved Royale, and she hates all other Bonds. We watched OHMSS afterwards, because Royale was most like that one, I would say.
She didn't hate it.
Quantum of Solace started to leave the "realistic" Royale behind and go back to goofy Bond. Like I said, if they can pull of a 3rd Quantum movie, I'll be really excited about that.
The Spy Who Loved Me is my #2 Roger Moore. And the theme song to A View to A Kill. ;)