The writers aren't stupid they must know just how silly some of these scenes actually are. The aforementioned Iron Fleet scorpion attack being one of them.
So they really have to sit around around a meeting table and say that it is better to write for drama then it is for realism, at least this season.
The scene with Dany's entire retinue no more than what a 1000 yards from Kings Landing walls was, to me, absurd. I said to my wife that when the gates opened up instead of Cersi's hand coming out negotiate, it should have been 10,000 Golden Company cavalry charging straight at the pitiful little group just prior to an onslaught of giant spears aimed directly at the Dragon Queens head.
Boom , battle of Kings Landing over!
And then when they panned outwards with the camera, there was the last Dragon sitting in the background easily within range of the castles 'artillery', just hanging out.. <sigh..>
Well, it's obvious they aren't writing the show for me specifically, but for a much larger group of people and i understand this, but i believe the huge popularity of the series (and i'm a big fan) has led to some very sloppy drama over realism moments that exceed the high standards the show set for itself through the first 6 seasons or so.
Couldn't agree more with your take...from a military tactic standpoint, well, there just aren't any. I mean, things get dumber and dumber with every battle plan (or lack thereof) and it seems like the only decent field general from the north was Rob Stark (RIP), who was a lousy politician. In addition to your observations, I had a few of my own:
1) How in the world, with that kind of air superiority and recon ability (including Bran's flock of ravens, which had been CONTINUOUSLY tracking the army of the dead), could they not send some scouts ahead to get an early detailed reports on the situation in the south (e.g., ship location, troop counts, armaments, etc)? I mean, that was a no brainer.
2) How do they just drop anchor and basically park the fleet, knowing there's another armada roaming the seas, adept at ambush, that knows they're in route...see point #1...with a sweep of an area that they left undefended and make sure to get the all clear. Friggin' Dany (whom the show writers have now turned into an idiot) is out there joy riding knowing that Cersei and her army has already developed "anti-aircraft" capability.
3) How is Jaime, Varys (little birds), Gendrey (blacksmith) and anyone else who has come from KL been completely unaware of the mass production efforts to make literally dozens/hundreds of the dragon-killing cross-bows??? I mean, seriously...how could something that obvious be missed by their intelligence?! How does Bran not see it???
4) And while this point pertains to the previous episode...how do you charge your most lethal fighting force (Dothraki) head on in open field against an army of dead at least 3-4 times their number without any special weapons?! I mean, the curved sabers they had were not dragon glass and wouldn't do anything until the red priestess blazed them up...but, seriously, how does Jon not see the same thing come into play against the NK as he did with Battle of *******s? Let the larger army charge and then light it up with arrows and fire when they're in range. Given what happened in his previous experience (*******s and when facing off with NK in earlier encounters), it made no sense that Jon would advocate for a charge by his forces directly into the undead army.
I get that the show is sacrificing certain things to create/contrive drama but this season is taking the show from the sublime to the ridiculous. I am going to stay the course as I have invested so much into it/the characters, but I fear I am going to feel same way I felt with Sopranos ending. Right now, our intelligence is being insulted.