Emergence of anomalous dynamics from the underlying singular continuous spectrum in interacting many-body systems