…everyone falls out of their seats 
All Hail The Bobs! I wholeheartedly endorse this endorsement.
Since we have included book series I would also suggest the Expeditionary Force Series by Craig Alanson. They spend a lot of time on trying to figure out how to adapt 21st century military strategy with technology so advanced it might as well be magic.
There have been moments of heightened creative thinking: the ramming scene from The Last Jedi, the Picard Maneuver from TNG.
Fundamentally real space battle would be glacially boring on-screen. Huge distances where you can’t even see the other guy, fantastic speeds, automated targeting, etc…
The Expanse does a pretty fair job, but even there, they’re usually WAY too close.
I think realistic space battle would be much more like the “Hunt for Red October” scenes between the Dallas and the Red October, but without the ships even being on screen at the same time.
Great suspenseful stuff, but not really stirring in the way that say… the battles in “Yesterday’s Enterprise” or “Return of the Jedi” were.
I also think that infantry combat would be murderously lethal in such a high tech environment, even by today’s standards. You’d be pretty much dead meat for any automated targeting systems/drones that would have better detection systems than your eyes, and people are still only going to be able to carry so much. I think you’d have to go down the “Starship Troopers” (the book) route of having powered suits, rather than having regular old footborne infantry out there with autonomous drones, assisted targeting systems and guided ordnance, etc…
I was just reading a couple of reviews, and more than one person compares the books to “The Martian”. It hadn’t occurred to me but it’s apt - an imaginative guy with a dry self-deprecating wit trying to solve highly unusual problems, fairly hard science albeit much more “out there” than just being on Mars and within current tech.
Not that Iain Banks was a model of hard sci-fi, but the way he handled a scene of ship to ship combat in Surface Detail made it very clear that computers were the only entities that could possibly comprehend the scale and speed of space battles. [SPOILER]I’m thinking of the scene where either Yime or Lededje tags along with the Falling Outside The Normal Moral Constraints as it’s about to go to battle, spends a few pages getting prepared to handle the fantastic accelerations and radiation fields involved, only to have the battle occur and finish in practically a blink of an eye. The passenger ends up watching a playback of the battle in ultra slow motion, in which FOTNMC took apart the opposing enemy fleet. It was hilariously anti-climatic, and the pace was reminiscent of Bambi Meets Godzilla.
Don’t fuck with the Culture.[/SPOILER]
It would be even less dramatic than that. Most science fiction battles use directed energy weapons or guided missiles but it really isn’t necessary to use anything that sophisticated. A railgun or Gauss gun firing a hail golf-ball sized ferrous projectiles in a pattern that is statistically unavoidable would destroy any opposing ship, so battles would be a matter of staying at the marginal edge of a pattern while sending out a fusillade of their own projectiles. There’s no hiding or cloaking in space, either; any ship of discernable size with a power system sufficient for interplanetary travel will be radiating heat and stand out against the background of space like a small star in infrared.
It is unlikely that infrantry combat as we think of it will even exist in a future where autonomous drones and robots are on the battlefield. Powered armor suits are great visuals for anime and film but even enhanced and protected in a suit people are just too delicate and easily disabled or distracted, and of course will become fatigued. There will always be a need for people making decisions (hopefully) and special operations will necessitate people making real time tactical decisions on scene.
Stranger
My opinion? Drones are very much an of-the-moment issue, and thus bad science fiction. Fifty years from now, who’s to say that people won’t be going, “Ugh, what was up with people in the 2010s and their drone obsession?” It’ll be like Asimov having microfilm in Foundation.
The thing is, space combat with the technology we can foresee is ludicrous and wouldn’t happen because of the unfeasibility of it. People would launch missiles and drones at each other or use mass drivers to delivery kinetic kill projectiles from hundreds of thousands of kilometers away and what would the final benefit be?
To even HAVE space combat, you have to assume an advance in propulsion, weapons and shielding technology, so why not make it interesting by making the assumption your story takes place in one of the swings of the pendulum has gone to defense and ECM and other defensive techniques such as powerful electromagnetic shielding that can deflect incoming kinetic kill projectiles make long-range attacks impractical. Then you can give a plausible reason why you have to be within a range that makes beam weapons feasible.
Same thing for infantry. Sure, armed drones will be a big thing in the next few decades, but at some point, remotely piloted vehicles will be too susceptible to hacking and signal intercept and jamming to be effective and we’ll be left with the choice of putting human boots directly on the battlefield or trusting lethal weapons to autonomous computer control, which we might hesitate to do.
It’s a bit of a stretch but I can see how a comparison can be made.
I imagine the ultimate form of space combat will be something along the lines of:
Step 1 - Find big ass rock
Step 2 - Throw big ass rock at planet
Step 3 - Hope people on planet cannot stop big ass rock from hitting planet
Step 4 - Run like hell
Step 5 - Profit(?)
I wonder if this question is like asking, “Are there any modern movies in which armies engage in realistic swordfights?”
Well, no, there aren’t, because technological innovations have rendered swords obsolete.
In the same way, I suspect that technological innovations including drones (or whatever name you want to give to mobile weapons platforms with semi- or fully-autonomous AIs) will render infantry obsolete. Why put soft slow squishy nearsighted humans on the front line, when you could have a killer robot there instead?
You got me thinking how anytime people beam in to a situation or try and breach a choke point they should be murderously mowed down. The first scene of Star Wars? That doorway should be piled high with stormtroopers…UNLESS…you have a Sith Lord leading the charge.
The Lost Fleet books by Jack Campbell do a pretty good job of it. They have FTL to get between systems but that’s it. A fleet shows up at the edge of a system, launches solid projectiles at stationary targets and starts driving inwards. 6 hours later they are detected by in-system sensors which rely on the speed of light and the defenders start maneuvering. Ship to ship combat is computer controlled as the fleets pass each other at 0.2c. Afterwards they see who survived and start at each other again.
Joe Haldeman in The Forever War, and John Scalzi in his Old Man’s War series, both take the same approach. The crews of military starships are basically just along for the ride once the shooting starts. Unfortunately, none of those books have been made into movies yet.
The Dark Forest Deterrent.
Already answered.
I read that, but find it pretty unpersuasive. When the choice is between having autonomous robotic systems, or having humans, we’re eventually gonna go with the former, because the folks who don’t are gonna die.
You say that, but what happens when (not if) the computer systems get hacked or have some sort of fault and they kill their own people, or innocent civilians? Hell, there is a LOT of flack right now about armed military drones and those aren’t even autonomous, just remotely piloted. I think you’re being unrealistic about the human reaction to what is effectively a Terminator.
In transcendence, there is a military battle near the end that struck me as using interesting tactics.