Pierce brosnan ftw.
For me he just was THE james bond. Suave smooth, getting the persona of Bond the best in my eyes.
Sean Connery second for his all-round bondness as people already mentioned. He had the charisma and physical thing. But...I dunno....he just wasn't smooth enough.
(oh and later seemed old).
The new guy, forgot-his-name, seems to have potential too