I agree, the first 2 seasons of TNG are just...bad. Especially as a fan, knowing what comes later, it's really hard to sit through those episodes. There are times when it looks like they filmed Season 1 with a fish-eye lens.
Later seasons, and I hate to say it, but it was those that werer produced after Roddenberry had passed, were far superior. All Good Things should have been saved for the first TNG film. Not only would it have made a far better film than Generations, we would all have been spared having Kirk killed by some falling construction. They could have easily still worked Kirk into a film based on All Good Things, what with all the Q Time Hopping.
I've seen a lot of DS9. Not as much as other series. I think DS9 is maybe the better overall series between the Trek series, but it's not really the best Trek series. I think that goes to Voyager. I watched the first 2 seasons of Voyager before losing track of it, but I re-watched the entire series a little over a year ago when recording them off of Spike TV. For its entire run, Voyager manages to out Trek TOS in terms of capturing the ideas and ideals that Roddenberry attempted to capture in his creation. It also managed to successfully portray female captain who was more than just a version of Kirk with boobs.