I see that you already got some really nice smoke clouds. Even if they look quite nice how they are some lighting can improve the visuals dramaticly. Think about a rocket going threw a cloud and illuminating it from within.
here is a nice paper about smoke rendering, just how to lighten smoke not so much how to create the shape.
http://www2.imm.dtu.dk/visiondag/VD06/graphical/smoke.pdf
The presentation is quite easy to understand and has some usefull tipps.
On the second last slide it is shown how to create a smoke volumn with a modeling tool and photoshop, the same can be done in realtime of course
ps: thinking about old times, lets see if I can put together a quick demo