Yep, @blues, I'd take Daniel Craig over Sean Connery. Connery's edges, in my mind, were over-polished. That was appropriate for the character as developed by Ian Fleming, but that was then and now is now. Craig, with his sharp corners and all, is more contemporary, thus my preference.
I thought Connery, as Jim Malone in The Untouchables, was superb.