Whenever any metal is added to an acid, the metal is oxidised to one of its positive ions, at the cost of either the acid which is reduced or water which is reduced to hydrogen. The product formed by reduction is what is referred to as the reduction product.
The reduction potential of $\ce{NO3-}$ is $0.8$ which makes the reduction of nitrate instead of hydrogen ion $\ce{H+}$ ($E^\circ=0.0$) more favourable. Thus it is the nitrate in nitric acid which is reduced instead of $\ce{H+}$ or $\ce{H2O}$. But at very low concentration of nitrate ion and low temperature, as explained by Nernst equation, the reduction potential decreases significantly and combined with overpotential effects, it is $\ce{H2}$ which is formed and not the reduction product of nitrate which is $\ce{NO2}$.
In the case of halic acids, the halogens cannot be further reduced. In the case of the sulfate anion, although it has a reduction potential of $0.17$, owing to overpotential effects, sulfate is not reduced, instead, water is reduced yielding $\ce{H2}$. At high concentration, the reduction potential rises sufficiently to overcome the overpotential effects, allowing the reduction of sulfate to form $\ce{SO2}$ at higher concentrations of sulfuric acid. Hence under normal conditions, only nitric acid gives a product other than hydrogen gas.
Reduction potential data
$$\ce{SO4^{2-} + 4H+ + 2e^- -> SO2 + 2H2O}(E^\circ=0.17)$$
$$\ce{NO3- + 2H+ + e- -> NO2 + H2O} (E^\circ=0.8)$$
$$\text{Nernst equation } E=E^\circ- \frac{RT}{nF}\ln Q$$
$Q$= reaction quotient, $E$=redox potential, $E^\circ$=Standard redox potential
EDIT
The oxidation of metal at the cost of reduction of another substance occurs whenever it is thermodynamically favourable. Usually, (except silver, copper) metals have negative reduction potentials, which makes their oxidation at the cost of hydrogen thermodynamically favourable as the $\Delta G<0$. This leads to a spontaneous redox reaction. This is not true if there is a kinetic or physical barrier to reaction. For example, Iron is rendered passive by nitric acid due to the formation of an oxide layer at the surface which prevents any further contact and hence stops the reaction.
