I genuinely feel the first seasons of the Berman era spinoffs are better than they get credit for.
TNG - perhaps I am a bit biased as this was the reason I became a scifi fan, since I was 8 when this premiered. Nostalgia can definitely alter perceptions, especially with how much I loved the character of Data... my personal scifi hero. But upon further reflection, there's a feel of exploration here that hasn't been matched until ENTERPRISE season 1. And while the low points are really low, the high points were really great... "Where No One Has Gone Before", "The Big Goodbye", "Home Soil", "Heart of Glory", "The Arsenal of Freedom", "Conspiracy". And they experimented more than the other spinoffs, which despite it appearing like throwing something against the wall to see what sticks, I respect the balls it took to go with that mentality. The franchise rarely took chances with the first season of a show like this again... DS9 would likely be the only one that can be even considered as taking chances, mainly for veering so far off the main format of STAR TREK.
DS9 - more than any other show, even TOS, the characters felt real right from the jump. They were clearly well designed and layered, and honestly I feel it was the best cast of actors, overall. Some of the episodes may not hold up, but the essence of the show and characters are absolute standouts. And it's honestly a joy to see an episode from here and one from season 7, and you can truly feel growth from all the characters.
VGR - they used some really great scifi concepts and ideas. While the execution might have lacked in some of them, they were really cool and wondrous. And let's not forget, it was cut in total by 4 episodes because of UPN. I always encompass those 4 when talking about the season, airdate order or not. I feel that decision hurt it more than helped, despite it including "ELOGIUM" and "TWISTED". The sum is greater than the parts, in those cases.
ENT - they brought back a sense of wonder and excitement of space travel. Plus, it felt real. The use of shuttlepods, the design of the ship, the utility-based style of uniforms... everything about the look of the show was fantastic. The only standing set I liked more than the NX-01 was DS9, particularly the Promenade.
Maybe I am being 'glass half-full', but honestly... they brought me a lot of joy over the years, and even more so while I was rewatching with my wife. How can I be anything but grateful for what they produced?