I’ll go with The Magician’s Tale by the author whose nom de plume is David Hunt. It has 20 reviews on storygraph. Kay Farrow is a colorblind art photographer working on a ‘streets of San Francisco’ series when one of her subjects misses an appointment due to being dead and dismembered – in a manner reminiscent of the serial killer her cop dad caught years earlier, shortly before he took early retirement from the force. Dad doesn’t want to talk about that, so Kay investigates other leads, talks to other prostitutes, a helpful homeless guy, the titular Magician, the victim’s mysterious sister, and works out his background and why he got murdered.

I’m sure I’ve read more obscure stuff, but this is one I’d recommend. Not to everyone since the subject matter is quite dark and sexual, but I thought it was well written.