You clearly don't have or know anyone with an actual mental disorder. There is certainly harm done by false diagnosis/labeling, and some people certainly milk their diagnoses, but the majority of people with mental disorders find it somewhat of a relief when they discover that they have a condition that 1) is not their fault and 2) has treatment options.
Think of it this way - if you grew up, and throughout your elementary and even high school experience, you had skills and abilities that other people thought were bizarre, people always looked at you weird and you didn't know why, you had uncontrollable tics that other people just didn't, you were frustrated daily because you had a very difficult time controlling your own behaviors, and you constantly got in trouble because these behaviors were judged to be "bad."
Finding out "other people have this problem too, and here's what you can try to alleviate the symptoms" is important to help these people become "normal, productive members of society." Your assertion that diagnosis will "lead the majority of them to make excuses" is completely unfounded.