It depends. The artist being a bad person doesn't automatically make the art bad. But I also don’t want to support bad people. So, relevant questions to me are: Is the artist still alive? Do they profit from my consuming their work? Do I promote them perhaps indirectly? The answers will be different for e.g. Lovecraft vs. Rowling, or rereading a book I already own vs. convincing my book club to buy new copies.