The only way to not have disappointing choices in game is, counterintuitively, not have any choice at all.
It's akin to saying "the only way to never failing is not doing anything". Yeah, sure. Yes, you can never achieve some perfection, still you can make a really good quest with multiple choices. As I said, classic Fallout games and Planescape: Torment are good examples here.
This discussion just doesn't lead anywhere...
That is exactly the point. The second you put in choices and player agency it is a crapshoot that might or might not fail for the player, you accept that from that moment on it is damaged goods. Your "good" examples are debatable base on that same metric.
Is it really good because the actual story and experience is good or is it good because it offers a large quantity of choices? And how did the player end up knowing there's actually a large quantity of choices. Saving and reloading just to see what's out there? Replaying? At that point is the game actually good or is it simply satisfying to see the sheer quantity and complexity of branches and possible outcome regardless of a single experience.
Think of a game, play through it from start to finish, it seems to offer choices and what not, finished it and it was a good experience.
Now go back and do it again and this time attempt to pick the other paths, and then you realize it didn't make any differences, is the game bad now because the choices were fake and there's actually only one path?
The thread is about what makes a good quest, what I see is people often say they want choices and criticize of game when it doesn't offer "good" choices. What exactly is going on inside their heads? Did they retroactively make that call after the fact after saving and reloading? Is it just a numbers game? or is it a complain of the game didn't offer the choices that they want or go into the direction that they want?
Likewise what makes so called good choices games good? Sheer number? Player carefully navigating a minefield of choices to finally get the outcome that they want? Or it just so happen they are into the choices and outcome available?