Low output MC carts require fewer coils, therefore less mass and therefore easier to move faster. So in theory can be quicker sounding, possibly more resolving.
But low output requires higher gain from your phono stage, so manufacturers offer various outputs to match the different gains of your phono stage.
I'd guess most people prefer low output, in general, if their phono can handled it.
But some prefer high output, probably because any gain is done at source (in the cart) which is easier for their phono to amplify.