Do tariffs ultimately help or hurt domestic consumers?

Context

Tariffs are taxes on imported goods designed to protect domestic industries from foreign competition. Economists debate whether they ultimately benefit consumers through job protection and domestic investment, or harm them through higher prices and reduced choice. This question has intensified as major economies have implemented significant tariff policies in recent years, making it central to current trade policy debates.