There have been people with schizophrenia on both sides of my family; my dad was schizophrenic. I
really wanted to know if I have any genes that indicate an increased risk of schizophrenia.
I signed up for 23andme on the first DNA Day sale and signed my parents up on the second or third one. They didn't have a lot about schizophrenia in their health data early on but added a few markers later. I don't have any of them (but my dad didn't either, so there's probably something missing from the picture). When my dad passed away a few years ago from pancreatic cancer, I wanted to know about that, too. Early detection is the only thing that can help with pancreatic cancer. Again, no markers for increased risk (and again, my dad didn't have any significant risk markers either, the science is still very new).
But, for me, part of the value lies in the original science they're doing. Even if they don't have useful answers for me today, I would do the questionnaires and such in hopes that it'd help somebody else later. Genetic prediction of diseases can be hugely valuable.
Sure, there's a lot of things that the standard advice works for. But, schizophrenia? Sometimes, by the time it is diagnosable the person is difficult to reach with treatment. Maybe knowing it's potentially looming will make them more likely to seek treatment at the first signs of trouble, rather than after the point where it is difficult to determine what's real. Likewise, pancreatic cancer...there are tests for it (not good ones, but if they know what they're looking for, they might catch it early), but they're not part of a normal checkup. But, if you know you've got family members who had it and have the genetic markers for it, maybe you pay for, and deal with the invasiveness, of the extra tests every year or two, in hopes that if you do get it you'll catch it early enough to have a hope of surviving more than a year.