I can't speak for the subs but as a Master I can say why I find humiliation a turn-on
the scenario is planned in advance, the sub is going to surrender herself to something humiliating
a sub's sweet surrender ALWAYS blows my mind, let keep in mind BDSM is a big mind orgasm

on the flip side something unplanned that is embarassing is just plain embarassing not humiliating