Tariffs are a tax, and their effect on an economy has to be seen in light of total taxation. There is a tax rate at which income of government is optimized (Laffer curve peak). Assuming the tax rate to be optimal now (which it may not be, but for sake of argument suppose it is) then one could push tariffs up if in compensation one pushed other taxes down, and end up with no net impact on the economy.
There is something to be said for national self sufficiency helping national security.
One of the succesful arguments for the 16th Amendment was that tariffs gave American business an unfair advantage. They got a protected market, but didn't have to pay any tax for the privilege. The income tax was sold as a way to level the playing field - as a way of making businesses pay for the privilege.