Bard is a poor choice of class for the main character, since the inspiration feature does not work on self. Since in every dialogue our MC gets dragged into the conversation, the civil application of bardic inspiration becomes unavailable.
That's what Shadowheart's
Guidance,
Persuasion expertise and (non-bardic) inspiration is for

Or play an Eloquence bard that basically can't fail almost all speech checks.
Although to be honest, the odd failure makes the game more fun (maybe not if you lose an Honour Mode run to it, sure).