James Bond star Sir Sean Connery left the role of 007 after his fifth outing as Ian Fleming's spy in You Only Live Twice, following a series of last straws on set.