The best luck I've had is finding a picture of flames against a black background, cutting out the sections that seemed to be blowing towards the viewer the most, then using screen as the layer blend mode so only the bright parts show. Usually makes the flames nicely and variably translucent as well.