Correlated spin dynamics and phase transitions in pure and disordered 2D S=1/2 antiferromagnets: Insights from NMR-NQR