...
There was indeed a lot of awful writing! But that's the same with any Trek series. Might I point you to the first season of TNG? Oy! ...
Lucky for TNG it came at a time when fans were hungry for more ST no matter how bad. By the time ENT came out the bar had been raised and fans were suffering ST overload. Character development in TNG also started our very rocky. How many chief engineers did we have that first season? And how did JL suddenly become an engineer? Security officers, doctors, navigators, the bridge needed a revolving door. I cannot imagine TNG surviving if it had to follow DS9.