There was never any fear that we’d lose the main cast
That's 90s TV for you. Today would be somewhat different though.
DS9 did far better with its war than Discovery did.
it's not a game, people get killed or seriously injured
DS9 covered that, in addition to the episodes mentioned so far, "Valiant" comes to mind. I wouldn't put Tears of the Prophet's up there though despite the decimation of starfleet and the death of Dax which wasn't really war related, as we didn't see any actual impact (other than Dax)
and for what ? because some politician says we need a war
DS9 did a great job of showing how war can become inevitable even when you try your best to avoid it.
or some arms dealer needs to make a profit ?
Again DS9 shows the detachment that's possible --
Look out there. Millions and millions of stars, millions upon millions of worlds. And right now, half of them are fanatically dedicated to destroying the other half. Now, do you think if one of those twinkling little lights suddenly went out, anybody would notice? Suppose I offered you ten million bars of gold pressed latinum to help turn out one of those lights, would you really tell me to keep my money?
it's not like someone attacked your country
The Dominion did fire the first shot when they attacked DS9, although arguably they were justified for
1) security -- the federation blocked their access to the wormhole
2) Bajor -- the federation was illegally occupying DS9 (
Captain, as a Major in the Bajoran Militia, I must officially protest Starfleet's refusal to turn over this station to my government)
Overall DS9 was great at showing not everything was black and white. And then there's Pale Moonlight just when you thought things were getting clearer.
and there's a need to protect your people your home your job your relatives etc
Should humans defend Earth? Mars? Vulcan? Angel One? Bajor? Ferenginar? Cardassia?
quite often your sent to some place you've never heard of
Siege of AR-558:
According to Starfleet regulations we're suppose to be rotated off the front lines after ninety days. Ninety days! We've been stuck on this rock for five months
Nobody had heard of AR-558, but it was crucial to get access to the dominion communications, which saves lives, maybe even planets. Sure Betazed was occupied, but Telar wasn't. Perhaps AR558 meant that millions of Telerite lives were lost.
for some dispute you have no interest in, that is even if they do tell you why you're there. " yours is not to question why, yours is but to do or die " what kind of crap is that ?
It's the kind that people who join the military sign up for. It's our duty, as the people who elect those that have to make the call, to ensure that they only make the call when the alternative is worse.
The one thing I feel that DS9 didn't do well was the background of the war. There's a strong argument that the Federation directly caused the war through incompetence and arrogance - and I'm not talking about the minefield.
Of course the changelings behind enemy lines, 'Martok', 'OBrien' on earth, 'Krajensky', all stoked paranoia in the Alpha Quadrant.
However go back to Season 1. The Federation did barely any exploring of the Gamma Quadrant. It was the Ferengi that made first contact with the Dominion, and all was going fairly well, until settlements started appearing (New Bajor, ok technically not federation, just like technically Norway isn't in the EU)
Effectively the Federation allowed the invasion of an area of space they knew nothing about.
When the dominion finally made it known that the federation should not be in their space, rather than close up the wormhole there and then and begin proper diplomatic relations (which may well have reverted to an agreement that nobody passes through the wormhole, on either side)
By the time "By Inferno's Light" and the attempted destruction of Bajor had come along, war was inevitable, but there's a strong argument that that point was reached because of Federation incompetence and arrogance, and it's the kids caught up in the war, and the civilians on planets like Betazed, that paid the price.