With regards to the author/artist discussion, I think there are a few things that make up the various axis's that the issues turn on.
Already discussed previously, but whether or not the author/artist is dead makes a big difference. Earlier in the thread someone made a oops and referenced HG Wells, to which a second poster said he had some problematic views as well, and a third asked a very pertinent question. "More than a typical Victorian man?" Because, yes, no one expects an author/artist from the past to have modern values. I am quite certain that Shakespeare likely held some views on women and government that would be unacceptable to the modern audience. It has been 400 years, a lot has changed in the world.
There is also the idea of "money well spent". I've mentioned in the past I'm a HUGE fan of the LitRPG genre of fantasy. Well, two authors who I had read in the past are Aleron Kong and Tao Wong, and I enjoyed their work.... and I have since learned that in the time between when I last read their work and now, they've done some bad things. Not like, horrid beyond belief, but they have been demeaning to others in the community, litigious and greedy about basic terms used in the community, and just generally not been good people. Kong in particular had a series I was interested in and has a new book he is marketing.... But why should I spend money on that book instead of money on an equally interesting series by someone who HASN'T been a jerk to people? It isn't like I have a choice between buying a book written by someone who has taken actions I disagree with or burning my money, I could just as easily by a book from someone who hasn't done something like that.
Will that second author still be a flawed human being? Yes, obviously, the point isn't to find someone who is perfect in all respects, but if I have a choice between someone who seems to hate that other people are active in the community of writers and wants to stifle them, or someone who takes up two spaces in the Wal-mart parking lot... well one of those imperfections is more tolerable in a writer for me than the other. And if I have a choice between the two, and both are doing good work... it seems obvious to me to support the person who is a more positive influence in the community.
And I think, it is between these two ideas, that DnD becomes a bit of a mess.
The vast, vast majority of the worst things in DnD were created by people who have since died, or have long since retired from public life. Their work is 50 to 40 years old, and as someone who has lived through the past few decades, a LOT has changed about public views on a lot of issues. My own views have shifted quite a bit. However, DnD maintains a lot of that early work and actively continues to publish some small parts of it. Especially until just a few years ago, WoTC held the position that all that old, weird, and baffling content was still canon. One example I mentioned before is that Tiamat has several dragon consorts... who are also her children... with the goal of having children who will be strong enough to be stronger consorts... I heard this from the Dungeoncast, who I know researchs old Dragon articles, but they don't directly cite their sources. But, oof, that's just nasty and weird and yet at one point was likely canon. On the other hand... canon is meaningless in DnD because we are all our own authors. DnD is itself more of a genre and a community than a single piece of art.
So, you have dead authors from the past, a modern company still selling their material, and we are also all out own authors making out our own material in the rule set which can be completely divorced from the lore. So, depending on your own position in the community.... it gets complicated. Do we preserve the work of people who clearly had different values than us? Do we demand change from people currently profiting off of work that has obvious problems? Do we defend our right to make our own material as we see fit, and not interfere with each other? It is a bit of a mess.
But, I think WoTC has found a good balance. They do preserve the old art in its original packaging and context, just with a warning label letting people know that it doesn't reflect their current values. They do attempt to not carry forward bad ideas and weird canon from that time period, I actually think it was a great boon to the company to declare anything previous to not be confirmed canon, because they can more easily look at some of the bizarre things put in Dragon Magazine and say "nope, that is no longer true". But, throughout it all, they tell us that it is our game, and that in your home game you can do whatever you like. So even as we hold the public company responsible for the public content, you can continue with anything you want to continue with.
And that seems to be the best answer we can come up with for right now. Deal with what is actively in the public, support those authors and artists doing good work, and try to muddle our way through as best we can.