I've recently watched the two series of adaptations from Georges Simenon's Maigret stories; released in 1992-3 by the British ITV company Granada; and starring Michael Gambon as the eponymous detective.
I found these extremely enjoyable. They are excellently constructed TV plays, with good teams of actors; and Maigret as depicted by Gambon was a very decent, likeable, and impressive detective - which is (for me) a vital aspect in the enjoyment of any such series.
The setting of 1950s Paris was strikingly convincing (although it wasn't actually Paris!); and (being made more than thirty years ago - unlike these woke-preachy times!) the characters also fit their appropriate time-and-place in terms of motives and behaviour; so that I got the feeling of being transported to another world.
**
Somewhat aside; I found it interesting that Simenon was able convincingly to create such a basically good man as Maigret - given that he was not himself such a person: at least not overall.
(...This negative evaluation of Simenon is from what I have gathered, and indeed it seems to be a general belief - I leave it to readers to explore this issue for themselves. By contrast; the goodness of Miss Marple is easily understood as exemplifying Agatha Christie's fine personality*.)
How is it that a mostly-bad man (as I think Simenon was) can write an essentially-good man like Maigret?
One answer is presumably that Simenon was, like everyone, a mixture of good and bad motivations; and he wrote Maigret from that which was good in himself - from the better part of himself.
Another aspect is that Maigret mysteries are light literature, in a minor genre - and do not attempt to tackle the greatest or deepest matters such as the conflict of spiritual good and evil, or the nature and implications of death.
It would - I think - be impossible for Simenon to write great literature. To attain greatness an author must draw upon his deepest nature, and for his vision of reality to be essentially good, would entail that he himself was personally committed to goodness.
In other words: the work cannot be greater than the man.
(The greatness of The Lord of the Rings is necessarily a product of Tolkien's greatness as a man; etc.)
But a man who was fundamentally petty, greedy, dishonest, unprincipled, selfish or the like - and one who was affiliated to such values - cannot produce genuinely great work - try as he might.
**
Note: Of course, an author or other creative artist may be good when producing a masterpiece of greatness; yet may change, may become corrupted, later - and I suggest he would then become incapable of greatness.
Something of this kind has, I think, been the case for JK Rowling - whose Harry Potter series I regard as great (although at a lower level than Lord of the Rings).
The Potter books (especially "Deathly Hallows") were written when she was committed to Christian metaphysics and values.
But Rowling later rejected her former ultimately spiritual perspective; instead embracing and advocating this-worldly secular leftist values. Her post-Potter work is consequently (it seems to me) at a very much lower level.
*This difference between Simenon and Christie - deriving from their authors - could be encapsulated by saying that Maigret is a good policeman; while Miss Marple is a good person.