I think Pierce Brosnan was great as Bond. I don't know if he's better than Connery or Craig but he's certainly in my pick of the top three with them.
The trouble is, he was saddled with some pretty bad films. Goldeneye was fantastic, but the next two were pretty forgettable which isn't want you want with a Bond film. And obviously, the less said about Die Another Day, the better.