If your going to be impartial you'd probably have to look at games that didn't make it, as opposed to ones that were fairly successful.
Like say back when "Wind Commander" was hot and you had people making similar types of games in the Renegade Legion universe, or trying to adapt it to Battle Cruisers like Battle Cruiser 3000 AD, or "Mantis" which shipped free with some computers.
Almost inevitably those games included some of the worst escort missions of all time, and wingmen who were either entirely useless, or capable of bogarting every one of your kills easily in order to be annoying, with nothing in between. Origin's AI for the time got complaints, but people forget about some of the things that happened when people tried to knock it off.
Some common complaints are also matters of opinion on design priorities rather than the AI being bad in paticular. To put things into perspective a lot of people complain about Sheva and the way she uses/squanders items and ammo in Resident Evil 5. On the flip side you also have people complaining about survivors in Dead Rising 2, who will not pick up weapons to defend themselves, leaving it up to you to decide what they will wind up using.
Speaking for myself, I think the AI in DR 2 is fine (especially compared to the first one) and I like giving them weapons, especially seeing as they don't break. I prefer that compared to say watching them pick up any piece of junk around, including something I might be after, or seeing them keep running off to find and use food on their own when they might be only a little injured.
I'd imagine working out friendly AI and getting the right balance is one of the hardest parts of game design.