Among DVDs of "Hoffmann" currently available, this is the only one that even begins to stand comparison with the superlative Powell and Pressburger film (whose ideas it occasionally borrows). Olivier Py's baroque imagination, which sometimes leads him into self-indulgence and incoherence, is well suited to bringing out this opera's darkness and he does an excellent job.
For me, the Prologue is overlong and the Tale of Giulietta is marred by Wesseling, who, for all that her singing is excellent, is overweight and lacking in sexual allure. It doesn't help that she is flanked half of the time by almost naked (in bodystockings) women of perfect shape, while she is bursting out of her corset (Petibon and Harnisch sing every bit as well as Olympia and Antonia while also managing to look every inch the part). As another reviewer has commented, the men are a bit weak. Cavallier is the best, especially as Dr Miracle, but Laho's Hoffmann is almost anonymous and completely fails to engage our interest. This may be partly Offenbach's fault but I don't think Laho can act.
Overall, there is more than enough in the show, both musically and visually, to compensate for these weaknesses but, if you only want one "Hoffmann", buy the "Criterion Collection" version of the Powell and Pressburger. It's in a completely different league and is astonishing value at £4.99.