Weapons of War

Why are you starting a symmetric ground war in that scenario? No matter how good your soldiers are that's just asking for trouble.

Modern humanity conducting asymmetric warfare against the Gould and Replicators gets my dick hard.
SOCOM takes control of the SGC

Exactly. The best thing to do in that scenario is doing spy missions essentially, assassinations, stealing tech, forging alliances, sabotaging their plans, making them fight one another… exactly what SGC program did.

It would have been funny if there was just a half sphere of staff weapons and zats that could be lowered over the game, configured to fire as fast as possible when activated. Kind of like a deathy version of the iris. Whenever SGC wanted to clear the gate region of some weirdo, we drop the hemisphere over, dial in, and activate.

All the enemy sees on the other side is the gate EXPLODING with plasma and lightning energy weapons being fired in all directions from out of the event horizon.

That's the Atlantis team's job.
Like the time they developed a bioweapon that caused their enemies to literally cannibalize each other.
Or the time they infected the humans they were "protecting" with a different bioweapon that had a mortality rate as high as 50%.
And then there was the time they were on trial for war crimes, and their main defense was bribes and threats.

Arguably, at the very least they took their sweet time about it and didn't really seem to be putting too much sweat into killing the System Lords.

As much as they made a point of always sending the MALP through the gate (as much to check for environmental concerns as hostile presence) but I can only remember one episode where the SGC fires weapons through the gate. Even just a couple of the security team throwing a couple of flashbangs through the gate would give the SG teams a couple of moments to clear the immediate area and take control of the gate.

I always wondered why they kept the Ascension Device to a single episode. It's fairly obvious for story purposes, but for all the Geneva-busting shit that the Atlantis mission got up to they drew the line at experimenting with augmented soldiers? Even if they could only get it working half way, having soldiers with the powers of a minor deity has got to be a pretty huge advantage.

That's because killing system lords actually makes the goaould race more dangerous.

They should have killed the queens.

Nuking Goa'uld Queens would make a lot of sense, at least until you can find/arrange a way to get the majority of the System Lords to attend the same conference …