Umineko: When They Cry has a great deconstruction of the locked-room trope. It’s a very long story (5 gigabytes of voiced lines!), but a hugely entertaining deconstruction for any fan of the detective/mystery genre. One of the best mysteries I’ve ever read. https://umineko-project.org/en/ is the definitive version, but please support the author by also buying the game on steam or elsewhere.
I really like Umineko, and that is the first thing that came to mind from this article. I gotta say the first episode (or was it the first two?) was rather off-putting for me because -- after a slow start -- it pretty much drags you through the mud with apparent fantasy elements that don't really seem to make any sense. I almost stopped reading. I'm still not entirely sure what to make out of the whole story, but I'm…
For myself the biggest problem was the very long peaceful intro in episode 1. It’s a long time before anything happens (lots of world building and setup)… although when the “fishy aroma” music track finally drops the impact is amazing. And it just gets crazier and crazier from there.