Characterization of the circumnuclear molecular and ionized gas across the Seyfert galaxy population