Don't forget Picard being blinded by his desire for revenge against the Borg after having claimed humanity has evolved past such negative emotions, which Lily even actually calls him out on.
Exactly!! I think too many fans buy Picard's frequent sanctimonious ramblings about how certain human traits and flaws are "centuries behind us" as the literal truth about 24th century humanity. What we see with our own eyes across the franchise tells us otherwise, and in fact, stories like "Star Trek First Contact" and "Picard Season 1" show that there really are a lot of people who will call JL out on his bullshit and that he needs to recognize what the real world is all about (including the fact that he himself can be an arrogant, insufferable prig). It's part of what is so endearing to me about those moments for Picard as a character...and actually help me appreciate him as a realistic member of humanity, and not some walking/talking version of Roddenberry's mid-70's convention rhetoric about why Star Trek is so special and prophetic.
Bottom line: I don't like smoking either...but to believe the series or franchise is flawed because it portrays humans doing human things is...well...a bit much.