I faint from pain or the thought of it. Why?

Vasovagal event. Nervous stimuli of the vagus nerve can lead to low BP (hypotension) and heart rate slowing (cardioinhibitory) reflexes. This vasovagal event can lead to fainting (syncope).