Legendary actor and Academy Awards winner Sean Connery turned down a film which won its star an Oscar as the James Bond actor called it a 'disgusting' role.