I don't like the site, and I don't like the company. That said, I've had on-site interviews at Google, Facebook, and the like not via my StackOverflow profile (which is pretty good, 20k+), or my blog, but directly through being hit up on LinkedIn.
I'm about to start a dream job next week, again after being contacted first on LinkedIn by my new employer.
Perhaps it's alright if you can post online about all the great work you do, or you have a name for yourself in the industry, or you make lots of OSS contributions on GitHub. Unfortunately I don't have any of those (yet!). But I do have a LinkedIn profile, and that's what got me on the one-way flight from London to SF next week.
I'm not defending LinkedIn as a company: I think they're pretty scummy. But if I didn't have my account, maybe I wouldn't have got this job.