Detectives are a common part of the Carcosa Mythos and the Cthulhu Mythos, such as Raymond Chandler's creations Steve Grayce and Philip Marlowe.
A nameless detective appears in the Incubus section of Fantastic Worlds, probably intended to be Marlowe.