I have also asked it to generated AWS related code in Python and it has something wrong every single time.

Its incrementally better than just copy & pasting from StackOverflow, since it will customize the code for you, but if you try to go beyond what can easily be found on StackOverflow it will fail you.