LSD does not turn shitty people into good people. Honestly, I think the degree to which psychedelic use permanently changes users' personalities or patterns of behavior in any sense is grossly overestimated by even most longtime users. It seems probable, or at least intuitively reasonable to me that LSD use tends to appeal to more thoughtful, introspective, intellectually curious and open-minded people, so a random LSD user might be more likely to be a "good" or peaceful person than, say, the average cocaine user, but that's correlation, not causation.
Many indigenous cultures have used, or are believed to have used, psychedelic drugs. Western druggies are most familiar with the trope of the peaceful, wise shaman from an idealized vision of Native American tribes. Fewer people think of Aztec human sacrifice rituals (it's unclear what drugs, if any, were commonplace among the Aztec spiritual caste, since so little is known about Aztec culture to begin with, but there is some evidence that they may have used mushrooms and/or ayahuasca-like brews), or the theory that the infamously brutal and violent Viking berserkers ate Amanita Muscaria mushrooms to enter a "divine trance" before battle, or the introduction of cannabis to the West during the Crusades in the form of Muslim assassins - the word assassin comes from 'hashishum' which literally means 'hashish user.' Some drugs produce effects that are inherently prone to encouraging violent or anti-social behavior and others do not (stimulants, for example, boost adrenaline levels and make it much easier for 'fight or flight' reflexes to be triggered even in relatively innocuous situations, while opiates tend to make users sedated and less responsive to external stimuli of any sort), but no drug yet discovered by humankind inevitably makes people 'better' or 'worse' - that sort of judgment is radically dependent on cultural context and on the individual psychology of a given drug user.