It's a throwaway moment, but my favorite Worf moment was the episode when he sat there, supremely uncomfortable, and announced. "Nice house. Good tea."

I almost threw things at the screen when Bashir, who graduated second in his class at Starfleet Medical and served for how long on starships and is assigned to a space station gets all giddy when his fling-of-the-week turns off the gravity in her quarters and announces he never knew zero-g could be like that.

Or the episode where they "divert all power to the shields" and the artificial gravity stays on.

The Troi character had a lot of potential, and most of it was wasted. About the third time she stood on the bridge and with a straight face announced "someone on the planet is lying" I gave up on the writers ever doing anything meaningful with her.

Picard sure bounced back entirely too easily from being Borg'd and from being tortured, and from living an entire alternate life, being merged with Sarek, and no doubt more that I'm forgetting.

It would be hard for it not to feel very similar to the one where Geordi fell in love with the holographic ship designer and later met her in person, only to find she wasn't who he thought she'd be. It would also permanently undercut the Inner Light episode.

Personally, I never understood why, having developed the holographic doctor, there wasn't a holodeck near sickbay (like, with an adjoining door) for use as an emergency major casualty sickbay extension. Even if you still used trained live doctors, the ability to instantly create necessary triage and medical equipment…

Speaking of airlocks. I have to rewatch, but at first viewing, it wasn't an airlock, it was a controlled door. There was no obvious venting mechanism or any sign of "wait while we decontaminate you" and any airlock worth the name won't let you open both doors at once.