> at first i was very hopeful i can finally 'build' now with my minimal tech skills
This is the problem. If you couldn't have coded it slowly in the old world, you will have problems coding it in AI world.
However if you have a lot of coding experience, you can now compress the time it would have taken you be an enormous amount. My experience is that I can now make extensive changes with very little effort, and very few dead ends. I've been able to take on entire secondary projects where I was just replication existing knowledge with slightly different tools.
Just this week I had a litmus test. I had an existing database that I'm pushing huge amount of data to. I decided to try a different underlying database. This would have taken me a full week of looking at documentation and writing supporting scripts, now I've done it in the spare time I had in two days of my actual work.
And it's not like the AI just did it all unsupervised. It threatened to do down the wrong path a few times, but each time I spotted it and steered it the way I wanted. I also asked it a few questions about curiosities I discovered in the emitted code, and that led to fixes as well.
If I didn't know how to code before, I would still be coding this alternative database.