It all depends on pressure.
Pressure is what determines if one powder burns clean or dirty.
Lead bullets will always be considered dirty, no matter what powder you use. It is usually the lube though, not the powder.
Your powder selection needs to coincide with the equipment being used to produce a load. Since stick powders meter like rocks, it would be a bad thing to use in, say, a Dillon progressive press. Although, some folks have been pretty creative with working though that problem. I couldn't find a picture, but some folks have wire tied aquarium pumps to the side of them to use them.
Ball powders have been blamed for flame cutting of frames.
They are harder to ignite but they meter like a dream in progressive presses. Some of the less expensive measures have a hard time with them too only for different reasons. They have been known to "leak" from some of the older Lee's.
Small flake powders, Bullseye, 2400, SR4756, SR7625 and others will cause no problems at all. The flattened ball powders of Winchester will work well too.
For progressive presses, I really like the Accurate Arms line of powders. All of them are ball powders and flow like a dream. You can see it on your chronograph too. Small ES and SD numbers. They light easy though. Standard primers throughout the handgun line, AA#2-AA#9.
Hope this helps!