The Niagara system is comprised of these 4 emitters! Most of them are just infinitely looping single sprite particles (aside from the little glowy dust particles), with the material shaders doing the actual heavy lifting
The cubes were the main thing to solve with this effect. I opted to make specific edge bevels and extrusions so i could utilise vertex colours to define certain regions for masking in materials
Here's the official version from Skyrim as reference!
I've started a little challenge for myself where I recreate some cool VFX from games - starting with this Alteration spell effect from Skyrim!