The much-loved director gave an unknown Sean Connery his first leading role as well as overseeing some of the biggest TV dramas of the 1970s and 80s