For me, both Hercule Piorot and Sherlock Holmes are well-structured detectives by their authors. But although the question is about a detective, I would like to share with you that the character that catches my attention the most and motivated me in reading detectives has been ARSEN LUPIN.

I'm sorry, he even seems smarter than the detectives to me.