Some common mistakes to avoid in SEO content writing include keyword stuffing, creating low-quality content, ignoring user intent, and failing to optimize title tags and meta descriptions.