Cleaning Kit Makes this much simpler to use, and opens this up as a semi-reliable primary weapon in any investigator that can take both. ( Venturer did too, but Cleaning Kit's primary advantage is you don't need to exhaust, so you can blow through the ammo much faster on the turns you need to.)
Which is most guardians, but also Joe Diamond, Jenny Barnes, Kymani Jones, "Skids" O'Toole, Diana Stanley, William Yorick and the two neutral investigators.
a +3/+3 per shot weapon is pretty good, even if you need to over-succeed. In Guardian investigators, you could even use Cleaning Kit (3) once per round for an additional +2.
Is this better than just grabbing a giant hammer? Maybe not, but this is more usable than it used to be.