While I liked (and otherwise agreed with) your post, it's wrong to say the TNG characters had no flaws:
Picard: Awkward around children, doesn't like his brother, has trouble with intimacy, suffers post-traumatic stress from assimilation by the Borg
Worf: Lacks a sense of humor, unable to relax, an absolute terrible father. Also in the early seasons his role in episodes was often to be the one who said the wrong thing that was disagreed with in the ready room.
Data: Lacks emotions (duh!) and thus misses out on many social cues.
Geordi: Absolutely horrible with women, and a little creepy.
Riker: Lost his ambition and comfortable coasting for the remainder of his Starfleet career.
Wesley: Where do I begin?
It's harder with the women, because they were not fleshed out as characters fully until the last few seasons, but they were up until them repeatedly shown as being too weak to defend themselves.
Those are character "quirks"...not flaws.
The Enterprise crew, with the exception of Worf and short-lived Tasha, were essentially homogenous paragons of humanity. And Worf was regularly a dismissed punching bag with regard to trying to bring diversity to the opinions of the rest of the senior staff.