As a teen I voraciously read my way through the Belgariad, and later the Malloreon, Elenium and the Tamuli.
Shocked to learn that Eddings and his wife were both convicted and jailed for child abuse prior to writing those novels.
I think books have a firewall between the author and the characters on the page. Actors, however, are a different matter. They are the medium.
The story was basically a police detective uncovering ritual cult activity by immigrants (from some unspecified place) in a NY slum. And the narrator (the detective) goes on and on about these strange foreigners and their dark skin, weird languages, heathen religions, etc.
But it only occurred to me after finishing that, though the reader is told from the start that weird cult stuff will ensue, the detective doesn't actually find anything nefarious until pretty late in the story. So with the story's timeline it's mostly just a cop being suspicious of foreigners for being foreign, until many months later he suddenly discovers unspeakable horrors of etc. etc.
You are using AI to form personal opinions?
<speechless>
As for MZB, I agree completely. No desire at all.
WRT to O'Brian, though--it's clear, as the OP notes, that he knew his faults, recognizes them in his characters, particularly Maturin, and shows them for what they are. To put it another way, his faults don't "poison" his books from within.
In the Sparhawk series, Faran was the likeable character.