213runnin,
It seems that you have drawn an arbitrary line in the sand. Do you personally refuse to listen to music produced by anyone who used drugs, or only those who have a public reputation as a drug abuser? When it comes to the Beach Boys' music, you seem to be saying that one shouldn't listen to Pet Sounds or anything recorded subsequent to that album. How about the songs on which Brian had no input?
You have indicated that your favorite Beach Boys tune is Sloop John B, which was released in 1966, yet Brian's LSD use began in 1965. Are you willing to accept that song because his drug problems hadn't, in your opinion, progressed to the point of "abuse"?
Do you reject the music of Louis Armstrong, Berlioz, Miles Davis, Chopin, or Judy Garland? If you include alcohol abuse in your "no-listen" list, you are rejecting an even greater number of very good musicians.
Personally, I listen to music I enjoy. I don't research the personal shortcomings of the musicians before I listen.