From Magnons to the Resonance Peak: Spin Dynamics in High-T_C Superconducting Cuprates by Inelastic Neutron Scattering