I got an example that's neither a design flaw nor a bug, and it still makes me angry after ~ 20 years.
When I played Fallout 2 back then, it drove me made that I couldn't complete a certain quest (finding Jonny near Modoc). I wasted hours on the mission without success. The worst thing is that it took me years to realize that in the german version of Fallout, which I played, every child was censored out of the game (because otherwise you would be able to kill children in the game!). I was not only angry about the rigorous and often silly* censorship in Germany (yet again), I was particularly angry about the fact that they didn't even care about leaving an unbeatable mission in the game
I was happy about completing the quest years later when I replayed Fallout in the original version
* The blood in Unreal was black. The enemies were supposed to be robots that lose oil after being shot
When I played Fallout 2 back then, it drove me made that I couldn't complete a certain quest (finding Jonny near Modoc). I wasted hours on the mission without success. The worst thing is that it took me years to realize that in the german version of Fallout, which I played, every child was censored out of the game (because otherwise you would be able to kill children in the game!). I was not only angry about the rigorous and often silly* censorship in Germany (yet again), I was particularly angry about the fact that they didn't even care about leaving an unbeatable mission in the game
I was happy about completing the quest years later when I replayed Fallout in the original version
* The blood in Unreal was black. The enemies were supposed to be robots that lose oil after being shot