Ravenous Bugblatter Beast of Traal
I'm completely with you. As mention, I am a proponent of miss damage - for the reasons you mention.One of the awkward bits of D&D is that we have tied that die roll to a narrative - If we make the "To Hit" roll, we HIT the target with the weapon. Meanwhile we have Hit Points that are specifically decoupled from narrative - they aren't "just meat".
If we decouple the d20 roll from that narrative, then we decouple "hit or miss" from "succeed or fail". If you succeed on the d20 roll, you do damage to the target - whether we narrate that as running them through with a sword, or them twisting their ankle trying to dodge, becomes a separate element - we can either use that as design space, or just leave it to convenience..
But what was proposed had no d20 roll at all, no success or failure - only draining of HPs, which is an effect.
But it is possible at range to not interact with the target at all, and I can't see a way to have the mechanics support that narrative. Every shot, even if you are not aware of it, will drain HPs.