Ideally, I would like a system were ranged attacks give diminishing returns with the logic that at first, the enemy soldiers stand close to each other so it's easy to hit a lot of people. When the lines begin to thin, it gets harder to hit the same amount of soldiers with a volley. This might not be the most realistic system for warfare of all ages, but it's an intuitive explanation for diminishing ranged strengths. And it makes melee units much more important, no? (not sure if it'd add balance though
)