The writers effectively admitted Barclay was their comedic whipping boy, in that exchange between Beverly & Troi a couple of seasons down the road when they discuss how much therapy he will need given everything that's happened to him.