I agree with Trylobot's late game ideas, but ultimately I'm waiting for future versions of the game to introduce additional core content and become even more editable (e.g. sound, multi-sector travel, time/event based events, etc.).
I hope that I'll eventually be able to create a lengthy mission on a huge map that has me doing things like "investigate distress signal" at which point I'll venture toward a crippled ship floating in space and once I get within a certain proximity of said ship (an event), pirate raiders will spawn nearby accompanying the text, "Arg, I hope ye be more cooperative than your friend. We had to teach him a lession", and then I'll have to brace myself for waves of pirates with a spawn countdown timer until I win the mission by either A, both ships surviving the attack waves or B, tow the crippled ship off the map using a tractor beam while fending off enemies.
My Starfarer modding fantasy in all of its glory. In fact, I'll create a suggestion thread.