The effect of non-equilibrium metal cooling on the interstellar medium