My first attempt at creating a tool using UE5
TL;DR: Just use sequencer to take video while rotating something and you can use those video frames as sprites for a spritesheet.
Plugins used: Render Movie Queue
Change project settings: Postprocessing "Enable alpha channel support in post processing" to "allow through tonemapper".