There are so many good missions tht I have played but my favorites so far are:

Conjoined
A Relic's Return
Evangeline
The Dissent Series.

There's one more I really like but I cna't remember the title but it's about the Klingons invading trill. ?Both my mains are joined Trill so it ws bound to pique my interest and it was really well done!