Has anyone heard of cannabis being ordered to help manage depression, anxiety or insomnia? Or has anyone just gone ahead on their own and used cannabis to improve how they feel?

The other night I saw a show on CNN (I think) that spotlighted a medical facility in Israel, where patients with serious medical issues were being treated with medical cannabis. Supposedly, it was doing great things for them mentally and physically. I wonder if cannabis can be helpful for psych problems? I wonder if there is a risk that cannabis can compound a psych problem, making things worse?