Suprisingly, I'd say there's a wide spectrum for military RP. There's the plain ridiculous, which I do (but do it correctly and know that it's this category, or else), and then the more authentic, which I also do, and then the realistic stuff, which I've tried (and while it worked fascinatingly well for a while, it staggered a bit). And I do have a lot of ideas in my mind, it's just the simple problem- it takes a lot of effort to control people, physically stop people from going batshit. Also surprisingly, I don't find everyone going "SNIPORZ PLZ", but I find that people don't click with characters into one an other. Like, they are never human beings under all of it. It's a personal complaint of mine, as I fall for it- but it feels as if they live to kill people in certain ways. They don't, they're human underneath, and while some say, SF operators are made of a lot of steel, and are absolutely focused on the task at hand, harder to break in ways, it's still human flesh in them you RP out. 

And I agree on that too- about realism/authenticity. I don't always agree with perfection, creative licence can take over when needed, to make sure it has a soul. But the scenario you listed is a perfect example of bullshit, that RPs in this genre can't be (unless you have a goddamn good reason for it and everyone is at least "in" on it), and that stories matter, that some sort of historical context is maintained. I don't mind having an RP where we take the piss and it has a certain direction, and sometimes, it is fun to do, when done correctly (but that's whole different matter altogether that I'll exclude for the reasons that it's a bastard to explain), but at least staying vaguely authentic in gear, actions and individuals is important. Some action keeps things flowing- but you can't have it all the time, there are tense lulls in combat, the feeling of stalking and slowly taking on enemies in systematic function. There are incredible stories of soldiers out in the real conflicts of the world- I would say that beyond a Call of Duty-esq scenario, it's about crafting an original story, that actually has a punch to it, whilst actually making you care for the characters, and bother to go "This is just about plausible- not entirely, but within reason.". 

Myself, I do have a lot of influence from video games, but it's just as bad with films. Zero Dark Thirty is good if you want to gauge how you know, those types of operations work, while something as abhorrent as Behind Enemy Lines III (I had the misfortune of suffering this film, regrettably) or Rambo for that matter does nothing. I like to use some video games, but I tone it back- with real life documentaries made in the current day, complimenting the sane facts that need to be out there, with a pinch of creative license to at least keep it somewhat dynamic. It depends heavily- but that isn't the problem entirely.

To me, it's the point of inexperience, and I believe there are a lot of people, you included, that could pull off a military RP. Don't buzzkill, be too hard-on about facts (boring people kill RPs, it sounds like a lie but I've seen it happen), but don't be a dickhead ultra-killing mad know it all SF unit. If your'e going to be an SF, fuck it, make them good, and justify it. In the end, it doesn't really matter what the game is about- just so long as the human aspect remains in these characters, whether they're Soviet conscripts sent to die, or Navy Seals, on a covert operation. It means that in the end, so long as the people are determined to at least remain vaguely authentic, and the right balance of tension and shit going down, as well as normal, sane RPing. 

In terms of ideas, I have mentioned before- I have a lot of ideas. A WW2 RP set in the midst of the chaos of the Warsaw Uprising, from doctors, scouts, soldiers, Jews and so forth- everyday folk in a horrifying situation. A modern-day RP set in Afghanistan, chronicling one last push into a valley by Canadian Rangers and US 1st Force Recon Marines, with everything slowly turning to shit, though the military humor that accompanies soldiering clearly there. An RP set in an alternative world, in which the Suez Crisis of 1956, following Anthony Eden's decision to push on rather than back down, brought about a new world (militarily focused on British troops). There's plenty of ideas that are original, and note how none are related to a video game (apart from the first, by coincidence, and the second by the vaguest of strands)- they are set about by simply an original idea.

So in conclusion, I'd say this- while the genre may be down on it's knees, I just really started this to put across the argument that it's a dried up part of RPG, and it's one that I feel left behind in as a relic. Perhaps it's the polarization of views, and I'm kinda left straddling for now.