To weigh in on this "too much/too little" business.
All I'm saying is that these are mechanisms and they they have to be considered carefully when placed in a game. If Bioware is trying to tell a certain type of story, they have to consider what kinds of outcomes they're going to allow from the choices they make available.
Less perfect outcomes can lend weight to an unambiguously golden ending. Knowing that you can do what the game lets you do and that the game can conclude in a less favorable way does make the more favorable conclusion sweeter. It makes it feel more earned. But you have to realize that at that point you really designing your game around that outcome because that's what the players will go for. And that shapes what the less favorable outcomes say about the situation and the characters.
This is all valid and a perfectly fine way to design your scenario. It worked well for Mass Effect 2's suicide mission.
On the other hand, if you want to create a difficult dilemma, you must necessarily avoid a golden third option. All of your options should have costs and risks attached. Maybe some less than others, maybe some favoring certain types of player or certain political and ethical perspective but there should be no unambiguous best choice.
And dilemmas are interesting. They're a major hallmark of the Bioware brand. Bioware has hit upon something that is truly special about this medium. Its fun to debate a dilemma amongst friends or watch a hero make a difficult choice, but now we get to actually consider these dilemmas ourselves. Do you save your friend or a dozen faceless people who mean nothing to you personally? That might be an interesting thing to debate in the abstract but its downright gripping when you're playing a character who actually has to make that choice and live with the consequences. When you either get chewed out by the Admiral for failing your duty as a commander or you bury a comrade, that lends weight to the dilemma. That brings it into focus. Thats ruined the moment you use the rocket pack you spend 3 hours grinding to build to allow you to save both.
That said, yes if the game lets you grind and make the rocket pack and then arbitrarily takes that pack away from you to enforce the dilemma, that is frustrating too. But it shouldn't stop the developers from trying to find a way to make a workable dilemma.