The point is that putting them in prison doesn't solve the problem and giving power to police results in inconsistent enforcement harmful to communities.
The point isn't that using some of these substances is "fine" but that it should be treated as a public health problem (like smoking) not a criminal problem.