To be fair, Event Horizon scared me as an adult.

In the vein of “kids are stupid”, the Never-Ending Story scene with the sphinxes.