I had it when I was younger and at uni because I couldn't handle stress, always thought I was going to fail and used to self harm to deal with things.
No, I didn't find it helpful, but then I've hated every kind of counselling I've ever had. What helped me was just getting older and working through things in my own head.
My boyfriend is a counsellor strangely enough, he is very anti-CBT. He says that it is driven mainly by a need to process people through the NHS because it is straightforward and goals driven, and doesn't require too close a relationship between counsellor and subject. He prefers therapy based on talking and giving the person a chance to open up and talk to someone and think about their problems, which I agree with. CBT is very "this is what is wrong with you, these are the steps you can go through to change the way you think and behave and here is a worksheet to take away with you" IMHO. Gets people through the counselling process in minimal time and they can say they've got results because they've given you the tools to change your own behaviour and the responsibility lies with you. Very treating thought processes and symptoms, rather than the time-consuming process of examining your own feelings, past and emotions.