TNG is flawed as fuck and a product of its era. It's a classic but get real.
Picard is assimilated into the Borg, doesn't have PTSD at all and it's not even mentioned besides the episode where he goes back to the farm and First Contact.
The show has almost no continuity.
That's the whole Borg/PTSD arc that Picard forgot about specifically that he got over it in First Contact about the only thing the TNG movies did right.
Who said they were flawless?
okay pedantic ass 
they aren't as good as you remember. happy now? many of the episodes of the vaunted old trek shows suck balls.
TNG is still light years ahead of Nutrek garbage. 
spoiler (click to show/hide)
Imagine trying to tear down something good so you can put a literal piece of shit on a pedestal.
Are you able to articulate an opinion without posting a bunch of youtube videos?
I like Picard and I find it to be very optimistic. Trek usually reflects its era. I think Picard is doing a fine job reflecting the dark/scary times of today. If you don't find it dark or scary that's on you. But I find it to be very optimistic and gets argues that even during the hardest of times we should strive to do what's right. I find it very encouraging that such a broken group of people can find common cause to improve the universe and I'm sorry that it has:
cursing
and smoking in it
Even Discovery, which has its flaws, has some good in it.
It's weird that some of the detractors from Picard argue it's not "real Trek" because there's alcoholics (!!!) in it as they pretend arguments between Synthol and real alcohol have never existed in Trek (O'Brien argues that synthol is nothing compared to a real beer) or that people don't drink actual alcohol regularly (remember Romulan Ale? What about Blood Wine?).
Then there's the argument that there's "too much brokenness" which is apparently impossible in Star Trek the same franchise that had a ensign get PTSD after he lost his leg in a battle, and refused to come out of a holodeck for days at a time because fantasy became better than the real thing. Or the time he was also on board a ship where members of the highest Federation cadet group reduced themselves to cultism as all of the higher ranking officials were murdered in battle.
Star Trek has never featured flawed people
It has never had people with problems
Remember the time Kirk became a racist towards Klingons because they killed his son? Star Trek can
never be negative or showed character flaws. Better judge an entire show because the first season is even over.
Remember during TOS when people judged Spock harshly because of his non human values?
A lot of these criticisms are baffling and have persisted in Star Trek before. It's most people that critique Picard in particular have never seen an episode of Star Trek. It's baffling, really.
