It is indeed a common trope, to the point where it’s often lampshaded or subverted. It’s not very popular to play it straight, since… it’s lazy writing. Still, if you’ve played Ace Attorney games, at least two major cases hinge on this central premise. In terms of actual books, I had to dig a little, but Agatha Christie’s Elephants Can Remember does use this.