I was once put on a low dose (50mG before bed) of Trazadone to help with my sleep disturbances. It did help with that, but it also seemed to greatly amplify my paranoid tendencies. I went from mild paranoia that I recognized as such to thinking my colleagues were conspiring against me. I finally hit a reality check and stopped taking it a week or so later. The excess paranoia was gone almost immediately upon stopping taking it.
It also caused me to have very disturbing dreams along a given (paranoid) theme. In the dreams I always had to accomplish a difficult to seemingly impossible task. At some point I manage to find a way to make progress and at that point the task is made more difficult or something that was enabling me to make progress was taken away. These also went away when I stopped taking it.
Now I am experimenting with over the counter melatonin to help with my sleep. The only one I could find is also spiked with theanine and valerian extract as well, but it seems to be helping. Wow, just reading the label... it also has 25% daily B6, 20% daily calcium (calcium carbonate), 3% daily magnesium (magnesium hydroxide) along with glycine and GABA. What a cocktail! Anyway when I take it an hour before bedtime I seem to actually get sleepy and sleep fairly well through the night, without extra disturbing dreams.
My only other medications are for high blood pressure and high cholesterol and the only noticed effect that might correlate is that my extremities seem to fall asleep/go tingly more often and in unexpected situations.
In general, I dislike pills and drugs. I have found that pain medications do little for me (a typical red haired thing). Even morphine and demerol did not really get rid of pain, they just made me so out of my mind that I did not care.