Yes, prohibition did help create a more powerful federal government, because people were not distracted with alcohol and could focus on productive things. The 1920s were a very productive period in the United States. The government could focus on other things, since crime was not something that needs to be addressed.
The conventional view that National Prohibition failed rests upon an historically flimsy base. The successful campaign to enact National Prohibition was the fruit of a century-long temperance campaign, experience of which led prohibitionists to conclude that a nationwide ban on alcohol was the most promising of the many strategies tried thus far. A sharp rise in consumption during the early 20th century seemed to confirm the bankruptcy of alternative alcohol-control programs.
Yes, Probihition did help create a more powerful federal government in the United States, because it helped establish how far into the citizens lives they could reach. It was only the beginning of how the government became more and more involved with the citizens. Some people see this as a positive thing and like more government involvement in their lives. Others see this over reach as a constitutional offense that the government has entitled itself to.
No, I do not think that the federal government got any more power from the prohibition. I think that the people fought so hard against prohibition that the government had no choice but to legalize the sale of alcohol again. This showed that the people are the ones that control things.
Prohibition created a weaker federal government in the United States. There were man hours, money, and resources devoted to something that was never going to be stopped. Plus, they basically lined the pockets of the country's worst criminals be making alcohol illegal, and had to fight against them as well.