Heroes of Might and Magic III - Complete Collection + Era2 + VCMI + Utility.

If there is an enemy stack nearby and the hero doesn't have a Sniper Bow, they can only attack in melee. Otherwise, the archers will always shoot, and it's impossible to block them. This applies to the pure SoD or Complete Collection. Mods may have different mechanics.