I have a couple of related earlier answers that might help, although the question of social stigma is only part of each:

• Did English executioners have trouble getting married? - please note that this is not the actual wording of the question, for reasons that will be clear enough

• Did executioners in medieval Europe develop mental illnesses as a result of their job? Are there any records of this happening?

I hope these are at least somewhat helpful!