Found a Guardian article from a number of years ago that looked into the effect of red cards on games nowadays vs way back when.. it generally said that in cases where teams were trailing and then had a man sent off, teams only came back to draw or win the game 11% of the time.. but this dropped to about 5% when through 80 minutes.
So I think teams coming from behind whilst being a man down is more an exception to the rule, rather than the norm… but then obviously gets a lot more attention as it’s an implausible task.