We propose an approach to enhance the mechanical effects of single photons in a two-mode optomechanical system. This is achieved by introducing a resonance-frequency modulation to the cavity fields. When the modulation frequency and amplitude satisfy certain conditions, the mechanical displacement induced by single photons could be larger than the quantum zero-point fluctuation of the oscillating resonator. This method can be used to create distinct mechanical superposition states. © 2015 American Physical Society.