Carbon is not necessarily stiffer or better of a vibration damper than alloy.
Numb hands will come down more so to grip choice, tire pressure, and suspension setup than the stem, and any perceived effect from the carbon stem will likely to be a placebo.
But if you have the cash, they are pretty trick!