Well there's "Psychobabble" by the Alan Parsons Project (from the "Eye in the Sky" album).There's the whole "Oedipus Tex" opera by PDQ Bach (from the "Oedipus Tex and Other Choral Calamaties" CD -- which also includes the choral piece, "How Many Psychiatrists Does It Take To Change a Light Bulb?").
"Twisted" (Joni Mitchell, "Court and Spark" album) is a classic ("My analyst told me/That I was right out of my head..."). This is also sung by Bette Midler but I don't know where.
I'll think of more soon and post back.
Alex