Cavity-enhanced superradiant Rayleigh scattering with ultracold and Bose-Einstein condensed atoms