I can tell you about it where I live. Not fit for purpose.
DD went to GP June 2015. Got assessed September. Had been cutting for six months. Anxiety and low mood. She'd also taken two small overdoses but nobody told me (over 16). CAMHS offered group therapy in the middle of the school day for six consecutive weeks starting two weeks after she started a new school. unilaterally closed her case when we said it was inadequate and inaccessible.
GP refused initially to help with referral to private counsellor as did camhs. Told to go to the internet.
Found psychiatrist. DD low mood and depression. Had cbt, didn't connect. Took overdose in zNovember. I found out four days later. On propranolol for anxiety at night and that's what she took. Related to worries about school work. Prescribed fluoxetine. Helped greatly.
At exam time took an overdose and went to a&e. Overdose was taken 26 hours before she took herself there. They wanted her to stay overnight for emergency CAMHS referral following day. We were allowed home and she was assessed by CAMHS on the Tuesday after.
CAMHS assured she would get counselling starting early in the summer hols. Then advised at beginning of hols it would start in six to eight weeks. Advised Friday that was stretching to 10-12 weeks.
Prevented me putting high quality care in place in the hols when it would have been more helpful due to misinformation.
So, in my experience, young people can expect a bug fat nothing from CAMHS. A complete waste of time. I think it might be ok if dc are travellers, have a criminal record, etc., but if they come from normal homes and have families who contribute to society the system doesn't want to know.
The select committee report was published almost two years ago. Where I live more money has been pumped in but services have not improved.