It depends on your skills level. For trivial beginner stuff, it's OK but then again.
For anything out of mainstream which no or very few examples are available for the model to train, it's pretty much useless.
I agree with you. I find it also true that free, open-source frameworks with tons of documentation and examples on GitHub/gitlab and the 'net work well with artificial intelligence. Especially Drupal because it is so heavily API driven (14 major APIs I think, last time I asked AI to list them all). The major LLMs, especially Claude are well-trained on both Drupal and Ansible in my experience. So go vibe-code a website and deploy it using Configuration As Code.
Especially after January when DrupalCMS 2 is released, (In beta over the seasonal holidays). Here's more information about DrupalCMS.
I also agree with you skill helps, (and probably makes all the difference the world). My long-term concern about the market was best said by Joey Ramone: "lack of skill dictates economy of style".
If what I wrote interests you, check out this Drupal Vienna 2025 keynote from October.