You are right about the hair-splitting of my French friend [Dupin]: — that is all done for effect
The speaker suggests that Dupin’s “hair-splitting” logic is not only for solving the mystery but also for showing off his intelligence. It implies that his reasoning style is somewhat performative.