It can take a couple of years to get to that point, and it's difficult because a bespoke code generator won't have the resources that an open source, widely adopted library will.
Also, you'll be responsible for building whatever connectors you need, as opposed to more popular libraries making plugins or expanding their capabilities.
That said, when done right, they can be extremely powerful and well suited to their particular use cases.
There are many examples out there you can look at. Google buffers for example. The generator I implemented at work started out doing something like Google buffers 5 years before Google buffers became a thing. But it has then been expanded massively by colleagues to do so much more. It has saved man years of programming work and has removed a lot of the boring repetitive work. I think that is why it was become so popular among colleagues. It is the first thing they install when starting a new project.