Sure, stimulants can work when you need to stay awake, focus, and produce a lot of stuff fast. Hugh Hefner was wired as fuck when putting together the first issues of Playboy almost single-handed, and of course militaries use them all the time.
What they won't do is improve the quality of what you do, at all. Even the Hef did have an editor who cut out all the repeated paragraphs and whatnot that his coked-up writing had.
(N.b.: there is great art of all kinds which has been produced by druggies and stoners of every desciription; however most of them didn't actually write them while under the influence. Writing about being stoned, high, wasted, or wired is not the same as writing while being stoned, high, wasted, or wired.)