I like episodes with Barclay in them -- because I think that Starfleet would be a pretty stupid institution if they demanded that only the perfect people can ever get in.
He is not perfect -- kind of eccentric in a way -- and socially awkward like me. I guess for that reason I kind of relate to characters like him.
On the subject of conflict, any story is pretty boring without it.
When in doubt, hug your teddy.