Driving Fast and Slow: Dynamics of Periodically Modulated Quantum Gases