Spin dynamics of density wave and frustrated spin systems probed by nuclear magnetic resonance