Spin Fluctuation Spectra and High Temperature Superconductivity