I formerly worked in the pharmaceutical industry, and although I have not personally used SFC, I know that the process chemists use preparative SFC to purify large amounts of compounds. The advantage compared to prep. HPLC is that vast amounts of (expensive to purchase and even more expensive to dispose of) solvents (MeCN, MeOH etc) are not consumed.
There was an interest in the mid-80's on the analytical use of SFC-MS, typical applications (off the top of my head) being surfactants, coal products etc, which at that time were not amenable to GC/MS or LC/MS with the then current column chemistries.