It sounds like you're describing a game that is less focused on Adventuring, and more focused on Influencing. Where your decisions & actions have a ripple effect on the world around you.
Whole cities impacted by the consequences of your actions. That kind of thing.
Like, playing Dumbledore, instead of Harry...
I can't think of any RPG game systems that specialise in that level or style of play... however, I think some of the
Sine Nomine games might be worth looking into -- as many provide very versatile character builds (combat isn't always the focus) and a vast array of sandbox tools for a GM to craft & create a world, or galaxy, to play within.
Stars Without Number Revised now includes Space Magic! As well as psionics.
Silent Legions is more akin to DIY-Lovecraftian Elder Gods & Cults.
Scarlet Heroes is your swords & sorcery flavour...
Then there's all the published add-ons & expansions that extend the possibilities; as opposed to traditional modules which define the plot-line & path for you.
Essentially, each of these games is underpinned by wonderfully crafted tools & systems that provide the potential for far-reaching settings & plot lines.
I would be willing to entertain an experiment, using SWN:R as a backbone for a freeform-style approach, if you wanted to try this in a scifi setting? PM me if you're interested.
Whereas the traditional D&D approach is generally much narrower, as the various versions are predominantly designed for party-led adventuring. Of course, you could try make D&D work for you, if that's what you know...