Confusion no good in middle of story (6)
I believe the answer is:
tangle
'confusion' is the definition.
(tangle is a kind of confusion)
'no good in middle of story' is the wordplay.
'no' becomes 'n' (common abbreviation).
'good' becomes 'g' (abbreviation).
'in middle of' indicates putting letters inside.
'story' becomes 'tale' ('tale' can be a synonym of 'story').
'n'+'g'='ng'
'ng' going inside 'tale' is 'TANGLE'.
(Other definitions for tangle that I've seen before include "Confuse" , "Complication" , "Knotted, twisted mass" , "At glen (anag.)" , "Ravel, snarl up" .)