Stupid and having no prospect of success as a sleuth (8)
I believe the answer is:
clueless
'stupid' is the definition.
(I've seen this before)
I don't understand the remainder of the clue.
Can you help me to learn more?
(Other definitions for clueless that I've seen before include "Stupid (so unable to do crossword?)" , "how I started this puzzle!" , "Totally uninformed about what's going on" , "Lacking knowledge and ability (informal)" , "Lacking in ideas" .)