I love Daniel Jackson but Michael Shanks is such a d-bag in basically every interview (and there are some very questionable "behind the scenes" stories about him...). In that clip he somehow manages to be the most obnoxious Comic Book Guy fan ever.. while being on the stage.
The 1-2-3 is REAL stupid, no arguments there. Well, specifically, the "3 shots disintegrates" is. The 1-2 is not. Killing someone with a "less than lethal" weapon is just reality. And you can potentially get some real awesome moments when Teal'c or Ronon show how much of a beast they are by tanking multiple zat shots before succumbing.
But also... the 3 is incredibly useful from a narrative perspective and is the same reason that Starfleet uses phasers. Having one prop that can fulfill multiple roles and act as a "get out of plot hole free" card (as mentioned with hiding the bodies) is incredibly useful narratively.
All that said: I do love that the Tau'ri were very clearly about "more dakka". Insert meme about Starfleet being afraid to intervene with other cultures and Stargate wanting to get their Nic Cage on.