The study of 2,000 people found that Brits enjoy more realistic heroics, with Sean Connery's James Bond coming out on top with 38 per cent of the vote.