I would have to go with Sean really just that accent makes your knees go all gooey however second would definately have to be Pierce who was definately a better hero than Sean just without the accent.
For my next James Bond I would like Euan McGregor please (preferably with as few clothes on as possible and rescuing me single handed from the clutches of some baddie at which point we get a little interlude in a nice hotel before going on to save the world together......
(note to self must stop drooling on keyboard now
)