Grampster, I try to separate the person from his music or acting or whatever. If I didn't do so, I'd be very limited in my choices of music, movies, etc.
Fistful, I got to thinking again about your question as to whether the Beatles will still be listened to 100 years from now, and about my using Billie Holiday as an example.
Few people listen to Billie Holiday with any regularity, but they do listen to groups that cover songs such as "God Bless The Child."
So, maybe some of the Beatles' songs will survive, but not their renditions of them.
As for music from the sixties, there was indeed a lot of psychedelic, leftist, hippie junk. But there was also an explosion of great work after years of pap. Only time will tell which songs live on to be sung by future groups.
Those that do live on, though, will likely have music fans going back to the original artists. As a white suburban teenager, I'd never heard of Willie Dixon or Howlin Wolf or Muddy Waters until I listened to the Stones. And that got me to go out and buy albums and singles (remember singles?) by the original artists.