For someone who is far not an artist like me, nor a modeler and has no intention to go pro, Milkshape is the best. Since I'm looking forward to SC2, I don't see a reason to not use Milkshape for SC2. As long as models can be created and exported for SC2, even if animations may not work properly, id rather use MS3D.
You should know that it is very easy to work with it, it doesn't take much HDD space too, doesnt install things that you may not want.