This is not actually true. If the warrant in your example was obtained based on a deliberate deception it would be invalid and the evidence from the search would not come in. If what you suggest was the case, there would be basically no point to the exclusionary rule since the police could freely lie in affidavits and have the warrants (or at least the evidence obtained from their execution) upheld.
The good faith exception is easy to apply if you consider the purpose of the exclusionary rule. The exclusionary rule exists to deter unlawful police conduct.
Consider the situation where the police request a warrant in good faith, and it is issued by a detached and neutral magistrate. On appeal, the affidavit is found to lack probable cause. Should the evidence be suppressed? The Supreme Court says no, because the police acted in complete good faith. There was no misconduct involved and applying the exclusionary rule in situations like this would not further its purpose since there is no unlawful conduct to deter. This is the proper application of the good faith exception.
By contrast, excluding evidence obtained by lying in an affidavit for a warrant would have a very pronounced effect on reducing unlawful behavior by the police. Thus, no good faith exception for your dishonest detective. (Actually, he may be looking at a perjury prosecution.)
Law school ruined Law and Order for me. My wife can't stand me explaining why everything on the show is wrong. Also she hates it when I yell "Objection!!" at the screen every few minutes during the second half of the show.