Condensation versus ordering: From the spherical models to Bose-Einstein condensation in the canonical and grand canonical ensemble