I'd say the actual experience of the interview can be a good thing, but the process as a whole is a huge waste of the candidate's time - especially if you don't fit the stereotypical niche of what a Google employee is (4+ years of CS education, thinks writing linked lists and trees is exciting, etc. etc.) Their decision to intentionally avoid giving any feedback to candidates probably stops people from gaming the interview process, but it also makes it a net negative for candidates who don't meet the unstated criteria Google is after - criteria that could often be screened for before a candidate ever sets foot on campus. They refuse to interview candidates for a position or a role beyond generalizations like 'software engineer', despite the huge breadth and depth of problems solved at Google - if you're lucky they'll quiz you on the stuff you actually know, but most likely they won't, and the questions will be very mundane. This despite the fact that actual hiring choices ARE partitioned to some degree (as much as they seem to want to pretend they aren't).
Most of the time interviewing with a good company is a 'why not' scenario: The only thing you have to lose is some time, and you'll learn some useful things from most interview experiences (even if occasionally the only thing you learn is 'this company is awful'). Google's interview process feels precisely engineered to avoid letting candidates learn anything whatsoever.
Companies like Microsoft or Amazon or Zynga all at least have a pretense of evaluating a candidate's specific strengths and weaknesses to figure out whether they're useful - if you're a compiler engineer MS will probably have some Visual Studio/DevDiv people grill you with compiler engineering questions, if you're a games dev Amazon will have you talk to people from their games department, and if you're a database guy Zynga isn't going to ask you game design questions. For Google interviews it seems entirely one-size-fits-all, despite the fact that they have core products that obviously depend on niche knowledge and experience.