AI Content Creation: Friend or Foe to SEO?