<rant>
It's fairly effective for some very niche things, like specific types of seizures, limited pain management without the impact of opiates or the ever popular "getting cancer patients to actually eat something". Unfortunately people tend to forget that in those cases it's a prescription medication, and that weed isn't some magical exception where self-prescription of strong psychotropic drugs suddenly becomes a good idea because of it's inherent groovy properties. Counter to the widely held belief, weed can indeed have unpleasant or downright dangerous side effects (ex: in my case it's a reliable trigger for my seizures, which makes constantly being recommended weed to treat my seizures Very Tedious) and it's not a good idea to prescribe it without exception.
It's a perfectly fine recreational substance, but much like alcohol just because it's used recreationally doesn't make it safe.
</rant>