While there is a complex spectrum of attitudes toward science, there are three clusters worth pointing out, specifically in reference to the provocative New Yorker article by Jonah Lehrer called The Truth Wears Off.
The decline effect is the notion that psychics lose their powers under continued investigation. This idea is based on the observation that subjects who do significantly better than chance in early trials tend to do worse in later trials.