High-dimensional limit theorems for SGD: Effective dynamics and critical scaling