This adaptation of three tales by E.T.A. Hoffmann, with a sprinkling of Goethe’s Faust, portrays the German poet as both narrator and hero recounting his love affairs with Olympia, Antonia and Giuletta. Robert Carsen’s spectacular production highlights the melancholy genius