Oh, prescribed drugs.... Well, obviously opiates are dangerous both acutely and in the long term, acutely because it is possible to cause death by an overdose by suppressing respiration, and chronically, because addiction is well known with opioids and has important effects not only upon health but upon social function and social integration. However, cannabis also is capable of causing addiction and therefore can cause similar problems, though if you ask me if there is a difference in severity, I would say that probably the edge is greater for opioids.
If you're talking about tranquilizers or benzodiazepines and anti-anxiety drugs or hypnotic sedatives, again, deaths from overdose are possible. The effects on function—on coordination, judgment, the ability to drive a car safely and so on—are similar among benzodiazepines, alcohol, barbiturates, and cannabinoids. I think it's not a very profitable exercise to try to grade them in degree of risk. They all have risks, but in general for medical use the dosages are controlled in an effort to achieve the greatest benefit with the least risk, and the instructions that a doctor gives to a patient generally say, do not use more than so many times a day, do not use for more than two weeks, and so on.
With cannabis, there are no instructions given. For medical use, there are or should be, but we don't have enough experience yet to know how effective that advice is to patients. But for non-medical use, there are no instructions. Therefore, I would have to say that the risk overall in the long term is probably greater, because there are no effective controls for non-medical use.