I wasn’t going to say anything, EDIT: But this conversation has come up multiple times. People, including trained professionals, miss enemies that are only a few feet away. It’s called panic fire and it happens all the time. Most of the time when you hear about a police shooting, they’ve frequently fired 5-15 shots and hit two or three, even when in the same room with a perpetrator.
I agree that the aiming system needs work because distant shots, even with appropriate rifles, have a very low to-hit. That said, I use a pistol and a shotgun all the time at around 8 tiles (shotgun) to maybe 12 tiles (pistol) and with a low skill level. I find them to be just fine. I spend two or three ‘waits’ before firing and it almost always works out for me.