As someone who has never (and likely will never) pass these kinds of tests, am I in a minority in thinking maybe they're a good way of filtering the non-geniuses? I.e. Maybe the reason I can't pass these tests is I really am not sufficiently skilled/talented to work at Google?
At some point, I think we need to accept that sometimes other people are not the problem.
Everyone has limits. However, people vastly overestimate the impact of intelligence and underestimate knowledge, experience, interest, and work ethic. If you like programming and expose yourself to a sufficient variety of problems and architectures, over time you'll slowly run out of situations where you're running into truly novel problems. At that point your intelligence will matter very little, high or low.
At some point, I think we need to accept that sometimes other people are not the problem.