I load target/medium velocity loads for 38 Spec., 9mm, 40 S&W and 45acp. My "go to" powder was always Bullseye. When I couldn't find it, I bought Red Dot, TiteGroup, 700X, CFE Pistol and happened upon 16 lbs. of W 231. W 231 has made a come back of sorts around my area; as well as most Hodgdon powders.
As most of us had to do for the past 2 years, you use what you can find and can make work. Was very happy with results from Red Dot with lead bullets. TiteGroup has worked very well for me with plated bullets in 9mm and 40 S&W. Haven't tried the 700X yet, but want to in 45acp. CFE Pistol worked very well in medium velocity 44 Mag loads that I worked up for a buddy at work in his Ruger Redhawk and 629-4. Haven't cracked open the W 231 yet, or my jug of Bullseye I traveled 6 hours round trip to get-saving both of those till I use up some of the others.
Best of luck, powder is starting to come more available; you may still be able to get some W 231 eventually.