The Impact of Damping in Second-Order Dynamical Systems with Applications to Power Grid Stability