Here is one concrete example of something that Google simply gets wrong.

They should pay external competent programmers to come in. Ask the programmer, using Google's public documentation, figure out how to do standard task X that the programmer has never done before. Say, build a Google script connector for a Looker report. Or navigate OAuth 2. Give them any necessary resources. And film it.

Do you have any idea how many ways that they would find to improve their documentation for this kind of use case? Or how much they would improve adoption of technically excellent products.