MINDS: a transition from H2O to C2H2 dominated disk spectra with decreasing stellar luminosity