I know people who have gone through the their hiring process, and they were sufficiently unsure if they would ever get on the team they applied for.
There's also the story of the Google+ UI lead who though he'd be working on another Google product, then got reassigned before he was even hired into G+ and hated his entire 9mo having never even met with Vic the VP driving G+.
(Only partly a joke.)