Zardnaar
Legend
Against 15 AC, to completely negate the -5 you would need to achieve a +18 to hit (because 1 misses regardless, so if after -5 you still hit on a 2, it didn't do anything). Archery gives you +2, Bless gives you another +2.5. You would need a +13 or so before archery style to completely negate it, which is possible at high levels with a magic weapon.
But yeah, since the tradeoff is better the higher your natural bonus, due to the fact that 5 becomes a smaller percentage of the number of values that hit, you can get close to negating it with those things: if you're, say, level 13 with 20 DEX then you have a +10, up to +12 with archery style. Add Bless and now you still have a +9 or +10 even after the -5, so you only need a 5 or 6 to hit. So you're only removing 3 or 4 ways to hit out of 19, which is definitely a good deal to roughly double your damage on a hit.
Except of course once your high enough level for that, the Cleric doesn't want to be concentrating on Bless any more.
You don't need to completely negate it.
Real life example. Hand crossbow level 11 or 8 20 Dex.
+ 11 to hit, -5 vs ac 16. You hit 50% of the time.
75% hit if you don't.
4 attacks a round as fighter.
2 hits -5 1d6+15 damage. Average damage 37
3 hits without it. 25.5
Before other buffing.
With a bow something similar applies but you get less attacks.
At low levels even with +7 to hit with advantage it's not that hard to hit and the is before any other buffing is done.
+7 to hit plus bless makes it +9.5.
Hitting 50% vs AC 15
Throw in action surge.
Put simply using as is always the best option as long as you can hit 50% of the time.
Buffed plus advantage I've seen it used on AC 20-22.