The Executive Functioning Paradox in Substance Use Disorders