It'll sometimes do dumb and/or redundant or too complicated shit. Pile up a couple of those and your codebase can get unmaintainable fast.

I find if you give it small chunks and keep an eye on it, it's great.

I think one of my recent prompts was "Create a procedure that creates an example configuration file with placeholder values. If a config file doesn't exist on start, give a warning and create the example config."

It also works great as a replacement for an ORM.