Same here. I'm currently trying to get the enemies' main base in Manhattan, and I can play for a few sec, perhaps a minute, until I have "oh shit! 3 is down" or "We Lost 2!" or whatever, at which point I can reload. (and btw. thanks for telling me I can have support. too bad support is grayed out although I NEVER called for anything during the entire mission)
The "It wouldn't be unrealistic to have them get up from the dead" argument ist hollow. It's not realistic neither that "the mission has been aborted because you lost one of your men". So what are they going to do. stand up, tell everybody "oh snap! we lose! cya later guys" and then walk back to the base?
As it is now, the thing you have to micromanage is not your teammates, it's micromanaging save-games. move and shoot, wait till an opponent is dead, SAVE! (hope to god that none of Razorteam died in the time it took to hit ESCAPE), continue ... one at a time... it breaks the game flow completely, and it's just annoying. Of course, I could restart the whole one hour long mission every time one of Razor dies (or one of the missions break), but who wants to do the same mission over and over again (while losing through no fault of yours at that) ???
EDIT: A quick and dirty solution you might as well include in one of the patches for the SP campaign that are hopefully coming would be to add a game option "Ignore teammates death in Campaign". If it's checked, dead team members will be revived when the mission succeeds (and the player can deal with his own concience to know whether it was right or wrong to do that .. along with saving the game from time to time and having FoF tags and whatnot .. All of which just are not realistic but imo needed in a *GAME*), if not you just abort the mission as you already do.