I really liked The Next Generation, but I didn't watch any TNG until the 3rd season after it had gotten pretty good. If I had seen any of the 1st season I would have decided to no watch another episode. The same for DS9 and Voyager having horrible 1st seasons. IMHO, Enterprise was the only one with a decent first season.
I puked my way through the first episode of TNG when it first aired. It was the last "Star Trek" anything I ever watched. Some people say it got better. I wouldn't know ...
Science Fiction in general has turned into stuff that really doesn't interest me. It's too bad; that was the genre I grew up with.
"Babylon 5: Our last, best hope for decent Science Fiction on TV." That and Stargate: SG1.