As far as I’m concerned the only kind of moustache that can always stand on its own is the Sam Eliot job - the old 1880’s classic that smiles when you do while never actually showing your upper lip.
Other than this, they must be judged on a case by case basis, and frankly most of them would be much improved by the addition of a goatee or other beard structure.