I have not ever watched it in German. (Though you still got to hear Christopher Lee as Haggard, as I believe he did both the English and German dubs for the role!) I don't think that the movie ever scared me too much as a kid, but it definitely has some bits that I would understand finding scary, haha. The harpy did freak me out, I remember.
no subject