Tested making a smoke flipbook with Blender and used it in Unity in a particle system. Would have wanted to render a better quality texture, but I'm content with the result.
Demo video showing the effect and the setup in Blender
Colored the grayscale texture with a gradient
Setup in Blender
Rendered and combined flipbook