I didn't know this about Freud, and without knowing more, it's hard to comment on this. I will say though that it raises some potentially interesting parallels with Buddhist philosophy, namely the inevitability of suffering/craving per the 1st & 2nd noble truths. And my understanding here is qualified by a sort of AA-inflection, which is the dilemma that you cannot realize your desires, even/especially a desire for spiritual growth, because that desire is always framed by the pre-enlightened/"small"/active addict self. Hence the need for the intervention of something bigger than oneself (HP in AA, something like the 3 refuges in Buddhism, or perhaps Buddha-nature).