Do lots of people get pancoast syndrome, or is it unusual?

Not very common. Pancoast syndrome is characterized by a malignant neoplasm (usually lung cancer) of the apex of the lung. It is about 2-5% of all lung cancer.
Unusual. Usually only with people with upper lobe lung cancer invading the 1st and/or 2nd rib. ..