Yes, guns are terrible at anything more than about 7 tiles, especially on automatic fire. 3-round-burst isn’t bad. 7 tiles is still a lot when almost everything in the game has to walk up and grab you. Rifles are the worst guns because they take the longest to aim, and aiming is necessary if you want to hit anything, even at 7 tiles.
If you’re frustrated, I’d recommend setting all your firearm skills to 20 in the cheatmenu as a temporary fix. They still won’t be as good as they were on low-to-intermediate skill levels a couple years ago, but they’ll be functional.
Also, 0 eye encumbrance and 0 arm encumbrance. A couple sweatshirts and a set of shooting goggles will turn god’s gift to marksmanship into a Star Wars stormtrooper.