Some put great care into them, others just stick a bunch of related songs onto an album and hope for the best. Pink Floyd's Animals is a terrible album full of tonally conflicting themes, but Sheep is one of my favourite Floyd songs of all time. You can pick a berry from a bush without having to scratch yourself on the brambles.
So what determines the level of artistry where we can forgive an atrocity?
If they have inspired derivative works, that are pro-humanist. Picasso was a horrible person, but his depiction of the Guernica definitely stirred a few minds to the atrocities happening at the time.
Sometimes it does. Problem is, no one wants to buy lemonade.