By the end of the first season of TNG, the characters had gotten pretty well hammered out, and we were able to have episodes like "Conspiracy", "We'll Always Have Paris", and "The Neutral Zone". Even in th emiddle of a writers' strike, the second season was able to give us stuff like "A Matter of Honor" and "The Measure of A Man". Even though there were some weak episodes in there, too, overall, by the tiime TNG hit its stride in early third season, enough people had gotten hooked on the better episodes of the first two years that it was more a matter of something good getting better than something feeble getting good -- which is what happened with Enterprise.
The TCW was just a bad idea. Having John Eaves design the titular vessel (which was a mistake in itself) instead of someone like Masao or Greg Jein was unfortunate. I have issues with the wardrobe that I won't go into here. The characterisation... They got better in later seasons, but Mayweather and Hoshi were almst totally left behind, and we had to endure too much of Archer trying to sound tough (which Scott Bakula just can't do) instead of just being
tough (which he can). And all the blatant continuity gaffes, just because Brannon Braga gives not one shit about such things... *sigh*
Nemesis might have been a good non-Trek movie, bot for Trek it was abysmal. The characters were all wrong, the situation was ludicrous, so many of the plot points were contrived beyond belief. This was not a movie for the fans. If it were, they would have gotten Academy-Picard right, they wouldn't have had a fucking dune buggy or its attendant chase scene, the android would have been Lore -- maybe lobotomised by the Tal Shiar in an attempt to get it to do their bidding, and Picard woud have been cloned after
he became high-profile, not when he was still the Captain fo the third-rate Stargazer
And Wesley would have been there with Robin Lefler as his date.