I think the AI is worse now than it ever was. The biggest problem is of course that the AI doesn't build units. They have 5 units and once they are dead, they do not replace them no matter how long the war is. I play on Immortal, which is supposed to be a challenging level. I don't want to think about what it must be like on lower levels. I'm not a coder but I can't believe it can be that hard to make the AI use it's production to build units.
Back at release, the AI was perfectly capable of beating each other. Most of my games had only a handful of civs left in the end game. Steamrolls happened. Now they rarely capture a single city.
It is also way too easy to out tech the AI, even at higher difficulties. I'm not a hardcore optimizer at all, and I still manage to beat them at Immortal.
Another gripe of mine is that the AI is way too easy to please. In all my GS games (3 finished so far), I have been best friends with all civs. Even the ones who "simply don't like me" in the beginning. Before GS, some empires always hated me no matter what I did.
One positive thing, though, is that they actually make sensible trade proposals now. I trade a lot with them and the deals are fair. Only problem is they can't take a no. They'll pester you every turn until you cave in and accept.
In conclusion, I am pretty disappointed. I don't think I will be playing Civ6 much until a major overhaul or a good AI mod comes out, which is sad because I love all the features of the game.
Just change some of the military settings slightly in the yields.xml and you get this on immortal:
I agree 100% though that the problem is that the AI needs to be more bloodthirsty once your friendly they never backstab enough.