For cast bullets most pistol powders will be sooty. In 9mm due to it being a higher pressure round the powder will burn a little cleaner on the higher end. In .45 ACP most powders are going to be on the dirty side.
That said for cast in both I use Bull's Eye. It works for me, and what I am doing well enough I am not going to mess with changing as long as I can find it on the shelf of the gun store.
No matter how many times you do it and nothing happens it only takes something going wrong one time to kill you.