Hi. In VAMStory by @hazmhox there is a tools folder and in that folder is a plugin called "vamsvfxeditor." When you load the CUA for the aurora effect, add this plugin to that CUA. Then if you open the editor there is an option to change the color. I just tried this and it made a really nice orange/golden color.
If you are interested in different behaviors of the aurora effect, like reduced intensity changes and movement, please start a conversation with me directly. I can create a custom effect for you if that is helpful.