Same exact story for me, we are about the same age. My dad was a Trekkie and got me started watching it young with Voyager and Star Trek 1-6 when I was only like 6 or 7 years old. Watched most of Voyager as I was growing up and all of the TOS and TNG movies. Tried some DS9 when I was a kid too, but like you I didn't like it at the time. Later on in my late teens I went through and did a full watch of all of the series, and since then I've gone through and rewatched them all on Netflix at least one more time, some more than once. Voyager is still my favorite for sure, but DS9 really grew on me by the time I was an adult and is now my 2nd favorite. Don't like Discovery at all and couldn't even bring myself to watch Picard once I heard it had too much of Discovery in it.
DS9 is much better as an adult and being able to binge watch it as it has storylines that last multiple episodes in the later seasons. Enterprise is very underrated. While I think it is the weakest Trek show from that era (TNG-ENT), I've rewatched it and it was much better than I remembered. The Xindi arc and final season were pretty good. Just ignore the dumpster fire that was the finale and end it the episode before.
I've rewatched some of TOS with my girlfriend and got about halfway through season 2 of TNG. Yes, we skip the worst episodes. Well, accept with TOS. The worst episodes are some of the best with how bad they are. Spock's Brain was terribly fantastic. She hasn't gotten into TNG, so when we get back to it I'll probably do a big skip and go straight to season 3 when it starts to get better. We've watched movies 1-6 and am waiting to watch TNG before getting to their movies.
Yeah, it's a real shame that so many people slept on Enterprise at the time, which got it cancelled. While the first 2 seasons were hit and miss, season 3 and 4 were excellent and they had great plans for season 5 right when the show got cancelled. The end of an era for sure, sadly Star Trek will never be the same again, both CBS and Paramount have proven that they really couldn't care less what TNG-ENT era Trek fans want from future Star Trek projects.
I agree about how much of a slog TNG season 1 and 2 are, those 2 seasons have too much of TOS in them and they're a big part of why I rank both Voyager and DS9 above TNG. TNG at it's best is great, there are some excellent episodes and First Contact is my 2nd favorite Star Trek movie after The Voyage Home, but TNG at it's worst is pretty bad, there were quite alot of dud episodes in those first 2 seasons, but also a fair few duds in the later seasons.