The Voyage Home and BOff Story Arcs in STO
Another pair of interesting ideas for STO I found on the forums.
The first is “The Voyage Home”, a framework around exploration type missions based on the story of Voyager.
The second is Bridge Officer Story Arcs, missions based around your bridge officers, after you set up some personality options (most importantly, sympathies to certain factions and vendettas against certain factions).