If you look at a Table of Thermodynamic Values for chemical substances, most substances have very close values for their standard enthalpy of formation ($\Delta H_{\mathrm{f}}^\circ$) and their standard Gibbs free energy of formation ($\Delta G_{\mathrm{f}}^\circ$). This makes intuitive sense because differences in enthalpy, which in chemical reactions is mostly just a signifier of internal energy because so little work is done by reactions, under normal circumstances correlates with the change in free energy of that system. When heat is lost through a reaction, that system has both less internal energy but also less free energy because the production of heat and then exporting of heat to the surroundings requires the 'use' of free energy.
My question: why do some substances have widely diverging values for $\Delta H_{\mathrm{f}}^\circ$ and ($\Delta G_{\mathrm{f}}^\circ$)? It appears that some substances containing nitrogen have the widest divergence for standard conditions of 25 °C and 1 bar, whereas most substances have a $\Delta H_{\mathrm{f}}^\circ$ and ($\Delta G_{\mathrm{f}}^\circ$) differing by no more than 30%. For example, $H_\mathrm{f}(\ce{AgNO3}) = −124.39$ kJ/mol and $G_\mathrm{f}(\ce{AgNO3}) = -33.41$ kJ/mol, and $H_\mathrm{f}(\ce{N2O4}) = 9.16$ kJ/mol and $G_\mathrm{f}(\ce{N2O4}) = 97.89$ kJ/mol.
A mathematical explanation would be helpful, but I'm most interested understanding this conceptually and why these nitrogen-containing compounds exhibit these properties. Are these properties more common among other substances at extremely high or low temperatures and pressures?