One of the most senior engineers here (someone with his name on many research and whitepapers from his tenures at Amazon, Microsoft et al), left Google for precisely this reason. He was bored of working on stuff that would never reach the light of day. It happened multiple times to him in his time there.