Adaptive Methods through the Lens of SDEs: Theoretical Insights on the Role of Noise