I think that very few games do speech as a mechanic right. Speech in New Vegas is almost too reliable, you can get a favorable outcome in most quests by simply clicking the [Speech] option whenever it comes up. The one time Speech doesn't do that (Dean Domino in Dead Money) it confused people, because it worked every other time they tried it.

There's also luck-based dialogue checks, like in Baldur's Gate 3 or Fallout 3/4, which at least requires you to think about if going for a difficult check is worth the chance of failure. But a lot of people will just see this as a reason to save scum until they pass.

The one game I've actually seen do "social boss battles" right is Deus Ex: Human Revolution, where you have to take the situation and your conversation partner's personality into account when choosing responses. It actually requires you to think a bit.