Fair, I was mostly thinking about "The Naked Now", where Riker, for once, is the uncharacteristically sober adult while Picard is nearly prepared to treat the ready room like a Motel 6 mattress.
Look, that's one of the worst episodes of the show, but Season 1 Dr. Crusher (before the later season clown makeup) could absolutely get it. No one would have blamed the uptight Frenchman after she unzipped the uniform a little while giving him the eyes. Also in that episode we learned Denise Crosby had a very taut mid-riff, and that Data was fully functional. So it had a few things going for it.
You get episodes like "Captain’s Holiday" which did Vash no favors
This episode was really the start of the push to make Picard a "modern" (in mid-90's terms) leading man, complete with fight scenes and love interests. To a large degree, this was largely at Stewarts insistence, whose ego was bored playing the calm diplomat.
This would culminate in the TNG movie "Action Man Jean-Luc", where he yells a lot, drives dune buggies, jumps off shit, and punches Borg in the dick while shooting tommy guns.
The whole character of Vash was even more creatively bankrupt. She was only there because Stewart was dating the actress Jennifer Hetrick (their affair broke up Stewart's first marriage) and he wanted her involved in the show. After they broke up sometime after Season 4, she was no longer on the show (although her DS9 guest stop may have post-dated the relationship, so producers apparently didn't hate her).
This is one of the rare moments where I agree with @AnOminous that Lwaxana was a better addition, not because she's sexy, but because it pokes fun at the chick-magnet space captain fantasy.
It's less a matter of poking fun at the Kirk stereotype, and more an inversion where stuffy Captain No-Fun has no defense against her aggressive flirting, teasing, disregard for his authority. She was annoying, but succeeded as a character because her needling was so successful at getting the stoic Picard blushing, much to the amusement of viewers.