A movie like the Sixth Sense is actually harmed by it because the film itself is so good that knowing the secret from the beginning makes the story 100 times more compelling.

Hard disagree. Both not knowing and knowing are comparable compelling, but different experiences.