Cavity resonances dominating the photon statistics in the non-equilibrium steady state