I think you might be getting away from the original premise a bit - compromising information is only effective if the target is afraid of it coming to light, and that fear requires shame. That’s all I’m saying; of course there are other ways of influencing people, but we’re not talking about those, we’re talking about having dirt on someone and threatening to release it to get them to do something you want.
Edit: Mostly, I’m highlighting the fact because of how Donald Trump has normalised not being ashamed of being a piece of shit. “Damaging” stuff comes out all the time and he’s basically like “Yeah? So what?”, and somehow that works. You could also look to David Letterman though; someone tried to blackmail him with his affair, and his response was to address it on national TV (which, whatever else I think about the guy, that was a BAMF move).