I made this effect using geometry nodes. You can adjust a few parameters such as fire speed and fire direction.If the fire is black due to the poly pile. Go to the light paths in cycles render tab and set the transparent parameter to 90. Eevee is still nice and clean. Hope it's useful