I've seen a moderately serious treatment that suggests that in a fight between our modern military and the Enterprise, the modern military might very well win. The Enterprise does have the ability to slag its choice of ground target, and we'd have a hard time retaliating as long as it stayed in orbit, but that is pretty much all they could do. It seems it would be trivial to block their transporter, shuttles may be shielded but they seem to be slow and one imagine we could wear them down even with conventional weaponry, and Federation ground troops are laughably incompetent by real military doctrine standards, armed with a single line-of-vision ray weapon that immediately gives away their position every time they use it, somehow no air support, and their use of this weapon is also incompetent. Any modern military would chew them up on the ground, to say nothing of the elite ones.
Also it seems like any ol' script kiddie from real modern Earth would be able to penetrate their computer security by accident. The Federation seems to be incapable of writing a login screen without a cross-site scripting arbitrary code execution attack built right in and easily accessible in seconds from the keyboard.
Seems the Reddit-originated movie-bound story Rome Sweet Rome http://en.wikipedia.org/wiki/Rome_Sweet_Rome has a similar issue with the Roman military vs well-equipped (but no resupply) Marines gone back to that age. Modernity works up to a point, but eventually it takes "boots on the ground" with massive resupply chains to win.
Just tractor some asteroids and drop them in the ocean. Aside from the tsunami's, a few weeks of saltwater rain would make it really tough to feed 6 billion people.
Swing back by in a year, and then really fight with whoever is left.
It also doesn't suffer from "Cool Technology in one episode -> never heard from again" syndrome, to give another example of an improvement over Star Trek.
If you've never watched it, I recommend it. It sort of dies with a whimper rather than a bang (opinions on the spinoffs are mixed), but SG-1 was very good for a very long time. Mainlining the first season episodes without commercials and in sequence is really a spectacular experience if you can stomach the "time wastiness". The first couple of seasons in particular really captured the sense of humans being thrust extremely suddenly into a new, huge universe without guides very well.
It's well established that all Goa'uld have the vast knowledge required to pull miracles out of their hats at will. They can and will punish any defector who doesn't have a huge advantage. Just look at how they allied against Anubis, when he made his bid for supremacy.
The Goa'uld are not pathologically incompetent; they're just wary of being disruptive.
My theory is that there are some rules of war that most people with transporter technology follow. We've already seen examples of similar conventions in Trek; for example those banning thalaron & subspace weapons (Nemesis & Insurrection movies respectively).
I think a more realistic theory is that the script writers simply had to draw a line somewhere and ignore the obvious inconsistencies from that point, or they would have never finished an episode.
It was an entertainment TV series after all, not a scientific paper...
I do agree anyway that many episodes were real turds. Personally I hated every single one with "Q" in it. Often those were not even internally consistent.
The trick is doing it right after it starts assimilating the ship, but not after it's successfully done so and suddenly turns on you and everyone else in the sector...
Not to mention perching all of your senior officers in a bubble, on top of the ship.
You can fucking reproduce historical figures with incredible fidelity, but you can't have a swarm of tiny battleships piloted by equivalent AI? Instead, you send your best people in a small warship right into the enemy lines, where they can be picked off at leisure?
Why aren't you people just firing a solid wall of torpedoes at the enemy? Why aren't you flinging black holes around like birdshot? Considering how many ships are lost per battle, why aren't you just launching cloaked warp cores at the enemy and decloaking & detonating when they're in their midst?
Did they completely forget about the self-replicating mines? Ignoring where they get the energy, why not fire a wall of those at the enemy? Right before the first wave hits, it should replicate another wall right behind them, and so on and so forth.