In Human Resources, Time Out and The Class, the Palme d’Or-winning film-maker – who has died aged 63 – addressed French and European society at all levels