I suspect we're getting down on this list...
TNG Season 6: "Suspicions" (written with Naren Shankar)
Another neat new technological advancement to be promptly forgotten later on, or because it's not often when a starship has to get a suntan by parking directly inside of it.
Surelock Beverly Holmes is an interesting idea, even if the episode's execution is even more wonky than my dating life mixed with the Borg, noting that Beverly is acting a lot like Shelby and the Borg's mantra was like my ex's.
Jo'Brill's redundant anatomy is - despite it all - thought out better than Worf's, even if his tender juicy innards are described similar to the Borg collective and even though the diagram she looks at shows... discrete organs. All except the good ones, of course... still, seeing the diagram in of itself is pretty cool. I'm pretty sure Data's cat was getting revved up too...
This is Guinan's last episode? Could have been far worse...
I think the episode as a whole could have been stronger. It easily would have in DS9, but seasons 5 and 6 TNG definitely are trying to - on top of everything else - incorporate a feel that DS9 would take and truly run the touchdown with. Which could suggest TNG was trying to groom the audience for the upcoming shiny new spinoff, but I disagree. Beverly has stood her ground before, just on nothing as epic as this.
And this episode would be higher up on the "good episodes list" if it really went with its ideas instead of feeling "plot by numbers".
What's left:
TNG Season 7: "Interface" (written)
DS9 Season 2: "Rivals" (teleplay)
VOY Season 7: "Unimatrix Zero, Part II" (teleplay with Brannon Braga, story with Mike Sussman and Brannon Braga)