Weed does seem to foster novel insights about longstanding things, but when it wears off the thoughts don't seem so coherent or actionable - imho. Then again I only smoke occasionally and socially, and haven't really tried eg coding while high.
I personally think all laws against drugs are immoral. But I see the present absorption of marijuana into the status quo and can only lament "not like this" - counterculture sucking up to power via taxes, regulatory complexity increasing rather than simply being erased, and persecution of other drugs even stepping up (not that I really want to see anybody putting needles in their arm. but public health, not societal banhammer). Feel good rationalizations like "change is slow" only make sense if you aren't simultaneously taking multiple steps back in other areas, and focusing on one substance seems quite myopic.
On the other hand, I don't know too many people where pot has had the reverse effect, and increased their drive. It does seem to have a numbing effect, broadly speaking.
Not saying I completely agree with the OP's sentiment, though.
Loosing desire is just a way to cope, switching one activity for the other, as both can't be combined. I am convinced the addictive effect, the positive connotation people allude to it are largely placebo.