Of course they’re worth it…
I’m also fond of archery (though I use proper bows for stupidly fast and automatic reloads. Those rats people are struggling with? A longbow laughs at them. Laughs as it takes their lunch money and pushes them down a flight of stairs). I do a lot of vehicular skewering too, but that doesn’t mean guns don’t have a place in my arsenal.
The same arrows that one-shot your average zombie and two-shot brutes will bounce harmlessly off of wolf spiders, skeletons, and various other armored mobs. I could switch gears entirely, make a mad scramble for my car and try to build up ramming speed. I could drop my entire invo and strip off my kevlar so that I can effectively wield a hatchet. Or I could painlessly swap in a sawn-off or a Glock with AP rounds and have the delicious pleasure of painting the black top with the offending party’s giblets. And this is not to mention range issues… archery weapons are limited to range 10 (15 with fancy ammo that I’ve never found), while 30-06 AP rounds have a range of 90. Also, incendiary rounds. Also, explosive rounds.
None of which is relevant of course, because that’s not really the question you’re trying to ask. I think what you want to know is, “are guns viable in the long term as a primary method of dispatching foes? Is it possible to find or craft enough ammo to solve most of your in-game problems with bullets and if so, is that experience fun enough to offset the hassle?”
Seems unlikely. Maybe if you heavily target particular kinds of structures, or carry a flamethrower and a jerry of gas. I doubt that’s how guns were intended to be used in this game. If you want to endlessly pew-pew-pew, there are a large assortment of games available that cater to your taste.