Connery in the "old flicks" was, how can I put this, fulfilling every man's fantasy. Making love to Ursula Andres, (I'd undress Andres!) Honor Blackman, Claudine Auger, Luciana Paluzi, Karin Dor, Dianna Rigg, (Roar!) Jill St John, ( Double, no, triple Roar!!) and Lana Wood, (gave me wood)Pierce was my favorite 007. Daniel Craig is a close second. Probably generational. I've tried watching the old Bond flicks, but I can't even get half an hour into them. They're just soooooo bad. But given the other flicks at the time, these were probably Endgame level entertainment. Have you seen Two Lane Blacktop? Bleh.
I'd pay to see Halle Berry play 007. She's such a sexy maneater, and probably a better shooter than most of us.