The people you cite are mentally ill and the drugs used are for mental illness. The drugs often do not make a mentally ill person 100% well but usually (not always) make them better. If they become violent it is usually not their medications but their underlying mental illness that is to blame. It's not a simple cause (medication) and effect (violent behavior) outcome.
Happy New Year- oldandslow