Hapless detective so confused with clue leading to gold (8)
I believe the answer is:
clouseau
'hapless detective' is the definition.
'clouseau' can be an answer for 'detective' (I have seen 'useless detective' mean 'clouseau' so perhaps 'detective' could also mean 'clouseau'). I am not certain of the 'hapless' bit.
'so confused with clue leading to gold' is the wordplay.
'confused with' indicates an anagram.
'leading to' says to put letters next to each other (some letters go before or lead others).
'gold' becomes 'Au' (Au is the chemical symbol for gold).
'so' mixed up with 'clue' gives 'clouse'.
'clouse'+'au'='CLOUSEAU'
Can you help me to learn more?
(Other definitions for clouseau that I've seen before include "I'm no match for Morse" , "useless detective" , "Peter Sellers' Pink Panther inspector" .)