I have seen results ranging from just generally okay to life-altering good in nearly all cases. There are many cases where the drugs are mis-prescribed or perhaps not needed at all. If you are depressed and sad over a recent occurrence in your life, it is less likely (although not impossible) for medication to relieve the discomfort.
Wyeth grossed almost 4 BILLION in sales on one single type of antidepressant alone last year. Glaxo another 2 BILLION on one drug alone.
I'm not suggesting that the marketing and sales of a drug should be a determining factor in the efficacy of a drug directly, but indirectly, the numbers simply cannot be ignored.
Another contributing factor is that the success of treatment is greatly increased when combined with some type of interactive psychotherapy rather than medication alone.
In answer to the question, I have not seen a single athletic individual experience a problem with their activities as directly related to the type of drugs you mentioned. However, I have seen obsessive trainees reduce training or quit entirely due to overall satisfaction with their lives. In cases like these, as one could guess, the training was used in an unhealthy way. It consumed their lives, pulling them away from their husbands, wives, and children. Training is a part of your life. Your life should not revolve around training.
You could easily wake up one day and realize that your best friend in the world is a barbell - professionalmuscle or not, that is not a good thing (and I consider myself to be a serious trainee).
If it does, then you should probably carefully examine why that is the case.