In my experience the by far best state to do any sort of work is being sober, clear minded, and in the zone. What psychedelics help with is expanding perspectives, looking at things from a different angle, getting the big picture, semantically over-exaggerating problematic details like a microscope, breaking away barriers, and shuffling things up.

When done responsibly, with enough processing and digestion after a psychedelic experience, this can lead to trying new approaches, which, combined with hard work over long periods of time, can indeed lead to extraordinary results.