All of the above sound great!
I'd also be interested to see if we could make very teamwork orientated missions, especially if the UGC tools allowed an element of randomisation. If it did, you could for example make a mission for five people where one designated 'leader' goes to one area alone, from which they're able to see an overview of what's happening that the other's can't see. That leader would then be able to direct the other four's defensive/offensive strategy, based upon what they can see is about to happen, rather than simply their experience of what happened last time.
For instance, it could start by the five of you warping into a large system with a Borg base/station/installation [of some kind], which is surrounded by a large number of Transwarp Corridors, around a wide perimeter. After defeating some Borg ships patrolling this area, you could all beam into the Borg 'base', and fight together to take control of it and therefore a computer station in it that displays the Transwarp Corridors' activity. The Leader would then be left alone to monitor this, while the other four beam back to their ships and head to whichever Transwarp Corridor the Leader can see is about to have Borg re-enforcements exit from. There could be several waves of re-enforcements on timers. Also, hopefully some level of skill on the part of the Leader in interpreting correctly which Corridor exit will be active next, or perhaps in recognising the most efficient order to intercept several waves of Borg coming through in a short period.