It is not one size fits all
I would not build a site without AI now. My last few WordPress sites are in the process of being converted.
But I also need AI to check my sites, and I need third party tools like Ahrefs. I am building my own tools and site audits, and I keep auditing, checking and refining them based on my needs. I will keep sharing those here, knowing they are often very subjective.
AI does not know what I need a website for, and that might change from one day to the next. Is it a business card site, or do I want it to do more? Some days I think I should just upload once a month. Then when do I need Astro to help manage the site?
Even with Claude, which is my preference today, there are differences between Claude.ai and Claude Code. I like to manage the content in Claude.ai and do the site work in Claude Code. It is a lot to do, and you still have to have some understanding of what you are looking for.
I am not ready for full automation until I know that what gets automated is what I need, not just what everybody else needs.