Lol. I guess each series has it own. TOS has Spocks Brain, TNG has Code of Honor, Ds9 has....wait does it even have a bad episode?, and Voyager has Threshold.
I think what bothered me most about TATV, was the fact that it was pretty much a TNG episode. I found that to be a spit in the face of the ENT cast.