Ugh...yes to everything in this thread.
I was happy when Bones introduced a psychologist into the team, but can't stand Sweets-as-psychologist! Unethical, pushy, and full of psychobabble. And yeah, that episode with Daisy's FBI clearance test? What. Nonsense. No wonder Bones thinks psychology is rubbish, if that's what psychologists are like in the Bones universe :|
I watch In Treatment and I quite like it, although none of the clinical psychologists I know work like Dr Weston (possibly because where I am, CBT is the main training and practice modality - rather than because Dr Weston's not a realistic character).
I love Lie to Me and I don't think it does a bad job portraying Dr Lightman (NOT a clinician) and Foster (a clinician). Occasionally some of the science and concepts are real, even! I think they accurately described positive illusions in one episode, and I cheered
I also love Criminal Minds and often I've wondered if they do have a psychologist consultant, as some of the stuff seems pretty spot-on. (Side note: I wish the latest season wasn't going downhill.)