Back in my day, we were more scared of psychotic episodes through DMT and instead, took LSD for the fun. I knew more fucked up people getting more fucked up than DMT actually being positive.
The positive outcomes it seems you're looking for is more apparent in psilocybin, according to a quick search. This is to say, as a past user of psilocybin and LSD but never DMT.
I personally reached a new positive outlook in life through psilocybin than anything from uppers and downers. But I was a regular user then and after a couple of years, probably will never use hallucinogens again.