So, in essence, my added value is translating the vaque demands of my clients into as efficient as system as can be.
Can the AI do it? Not yet I think. Maybe someday, for now I feel like clients of mine simply have the vocabulary, nor the mental models, to guide the LLMs. Ie, they have no idea of what one-to-many is, or why it's smart to put some information in separate tables, whereas some information is ok to filter row-based on a user attribute, etc.
I guess my trick is that mostly I'm my own customer. I'm a late stage career expert in netcode, so I pretty much have this long list of things I've been wanting to create for 20-30 years now... I'm still working through this, and each new thing I make, it creates 2-3 new ideas to explore! It's fun times :)