Silver screen giant Sir Sean Connery was perhaps most famous for his role as the martini-swirling, 007 agent in seven James Bond films.