He eventually finds the true solution, which perfectly explains all the evidence, and usually involves a complicated plot by someone else committing the crime in such a way to get an airtight alibi, or to frame the first suspect, or both.

Reality doesn't work that way. In reality most solutions don't explain every clues that you find. A lot of clues are just random noise.