I've never fainted but got close to fainting quite a few times, always due to pain or just being squeamish, like when I accidentally put my finger into a rotating disc rotor - that didn't hurt much but it looked quite bad and triggered off that reaction.