I once, as an exercise for a writing class at a local junior college, wrote a SS about the fauna and former sentients of M113, in the form of a news interview with the son of Robert and Nancy Crater (although Captain Sulu appears in it). And I also wrote a Borg origin SS, for that same class (although V'GER appears in that one). Both, of course, unpublished (except that I think one of them might have gone into the class anthology).
Now if you'd be happy with a milieu that's a lot like
ST, (and you like ADF's novelizations), then I humbly suggest ADF's Humanx Commonwealth books.