LLM's can help with all of the above. Deployed an app with a backend, frontend, docker database and more with gitea on my NAS just yesterday. Have little knowledge about how it did it. Now I have a git remote to which I push and the app updates itself.
I guess it works well until you hit a stateful failure. My concern would be Day 2 operations—debugging a database issue or networking partition without a mental model of the underlying architecture seems pretty painful.