I really like the fire effect from this page. All I did was create a mostly transparent brush, paint in the bright yellow and orange range, and then airbrush a layer behind it.