But would you have felt the same way if the story had simply continued on a different course (see the discussion of the same topic in the sanity and Mythos points thread)?
IF the story would continue in a different direction after the quest has failed it would be much better.
But what I really don't like in Fallout's 1 time quest is that after you finish it the game would end.
This leaving you a limited time to explore the world.
So in most ceases I'm against time based quests.
But there are some ceases like minor quests say for example - bring a cure to the king within a week, if you fail to bring it to him and he dies then his son will be the rules for better or worse OR the people will upraise.
There is other issue however, that most if not all quests if solved the "right" way gives you bonuses and prizes , but none thought of rewarding you if you fail the quest, like in my example - if you fail to bring the cure to the king then a better king would come, or even your close in game friend could be the king which is far better then actually solving the quest the "right" way.
In most games you won't get rewarded of being "evil".
I remember playing some NWN1 mod (forgot it's name) , I have tried to be evil - and all people turn their backs on my and I wasn't rewarded in any way.
In the real word evil bastards do get rewards for their deeds.