I like Barclay and even loved that he made a cameo in First Contact
, but I thought they made him too much of a buffoon there. He was more of a caricature than a person struggling with real shyness.
One thing I never understood is why Troi never felt his attraction toward her. I know it's just the writers ignoring her "empathic" abilities for the sake of the story, but it's still annoying.
Maybe she learned to tune it out due to every guy feeling that way.