I have been reloading for 40 odd years, but I am fairly new to pistol reloading. I came in with no preconceived notions of any powder.
I do have my favorites for rifle, so I know the feeling.
My father left me Bullseye, Unique, 2400, P5066, 231, and about 10 others.
I started buying my own powder, and bought most of the pistol powder made by Alliant, hodgdon, Accurate, Winchester. And just shot all of them to see. What I found out is most powders will do its job, but the BE86, CFE, and Autocomp keep coming back as the ones that are clean, and accurate, and can be used in any, but the full power loads.
I still use 2400, 296 for full power, but Autocomp, CFE, and BE86 can get you close to full power.
I don't need to replace 231, I have 20lbs of it, but I prefer to use BE86, CFE, and Autocomp, and sometimes WST. They are just as clean, and acccurate as 231.
BE86 is versatile enough to do away with Bullseye, and Unique.
I Have a sneaky suspicion that CFE, and Autocomp are sister powders, and the reason HS6 is going, is because it is too close to both.
For plinking there are probably 10 powders I can reach for that do just fine. No change in impact, or accuracy. Some may be dirtier, but I never cared about that, accuracy is still king.