Realspawn posted a long time ago, a tutorial about a tornado and it was pretty nice. He was using 2 or 3 models with some transparent textures and some particles at the bottom of the model. Them he was making the model and particles to rotate different directions.