I've been in therapy provided by CAHMS for around 4 years now... I've had three different therapists (two clinical psychologists, my current psychiatrist).
And kinda. It depends who you have and if they're a good fit for you and if you're prepared to be proactive and tackle your issues, not the organisation itself IMO. When I first went with self injury, mood and eating issues, their response was "it's perfectly normal, bye" [not exact words] So I wasn't very happy with that. There was a LONG wait between the consultations and actually scheduling regular appointments, too.
My first therapist [clinical psychologist] was useless - nice guy, but very bad at what he did, would go off topic a lot, was disorganised, and seemed scared of what he was doing. He was only newly qualified.
Second therapist [another clinical psychologist] was amazing, but she seemed to worship 'The Manuals' so only ever went by the book. Helped me a lot nevertheless.
My current psychiatrist is amazing. Didn't like him at first and he pisses me off at times, but he's very honest and changelling, which is what I need. I've made a lot of progress. He seems to love his job.