I grew up on Brosnan too, saw World is Not Enough five times in the theaters. Though at my family cabin we had a shelf of VHS tapes and Dr. No, You Only Live Twice and For Your Eyes Only were among them. So even when Brosnan was Bond to me, I was really into Connery's Bond and knew of Moore's thanks to seeing one of his better movies.
I love Craig's Bond, I think it helps that his was a reboot of the franchise. Helped me in not comparing him to past actors so much, since he's a whole new story.
Maybe I'm biased. I did see Casino Royale's premiere in London, even got to walk the red carpet behind Craig. Here's some shameless pics:
The theater before they let us in:
http://i.imgur.com/Wrjkd.jpgView from the red carpet:
http://i.imgur.com/YvCCr.jpgShaky pic of the back of Craig, he's the one in the middle. We weren't supposed to stop and snap photos but I did for the hell of it, You Only Live
Twice Once:
http://i.imgur.com/QTHud.jpgEdit: Fuck it, since I'm being a dirty name dropper, we also got to spend an evening hanging out with Christopher Lee:
http://i.imgur.com/1SbzV.jpgHe is friends with the guy who organized our trip, so he set up a dinner party for him and the fifteen of us on the trip. He talked a bunch, going on about wanting to be a singer but ending up as an actor. Got him to autograph an album he released at the time and shook his hand, I didn't know what to say so I said "You were fantastic in Lord of the Rings and Star Wars" and he thanked me and said they were the two things he was most proud to work on in recent years. Most awesome celebrity moment of my life.
One thing I learned that night: he hates squirrels. HATES them.