I can't believe that nothing mainly concerning the Ankh Morpork Watch has ever been produced. If nothing else, they could be the source for a great TV show, but so far nothing has ever been made. It's weird.
That series is good but not great as writing (IMO, of course) but I think would be incredible on screen. Film or high budget TV series could both work.
I think a creative filmmaker could play with that. View the same scene from multiple perspectives, show characters (and the audience) making assumptions and drawing conclusions because they don't have the full story. Maybe you never fully reveal what is actually happening, and let the audience fill in the gaps.
The narrative itself might not be enough to draw out a full mystery, but maybe you delve into the backstory and the supernatural elements at play a bit more. Or maybe it's all drug induced, from the art to the mass hysteria. Maybe the townspeople assign meaning to chaos, and their faith is tested when things don't go to plan.
But you have several interesting characters to explore, none of whom ever have all the information they need to understand everything.
I would love the enders saga completely done in a faithful way. I can see how it won't be, of course, but it brought me to tears so many times I'd love to watch it (and share it with non-readers!)
Working through the dune series would be great , too - also not really feasible