So land taxes, VAT, and income taxes are good; capital gains taxes are middling; sales taxes and luxury taxes and tariffs are bad. Tariffs are among the worst in this hierarchy because their incidence is - to an economist - arbitrary. In classical economics, specialization is good, and industries should go to whichever country is most efficient at providing them. Any sort of national tariff interferes with that: to the extent that the tariff succeeds at collecting revenue, it does it by making consumers choose an inferior product (in the sense that without the tariff, they would've chosen differently).
I'd expect the political rebuttal to that is "But national security - we want to make sure all our homegrown industries are competitive and we can make complete supply chains within our borders." I suspect there's an element of Lake Wobegone self-deception in there though: people think that they're better at everything than they really are. When nations cut themself off from the global economy, they often think that they've made themselves self-sufficient right up until a foreign power that's been trading the whole time shows up in your capital city with a fleet of gunboats to forcibly open your country to world markets.