Been shooting black for over a half century now, and I have never found any substitute for DuPont ( sorry Goex) black. Pellets are unreliable, 777 is not consistent, Pyrodex is probably best but isn't as powerful as black. hey, it has worked fine for 1,000 years or so. Why change?
I've not been shooting for nearly as long as you've probably been cleaning yours but I have done a good bit of asking questions and researching, and I've done my best to shoot as much as possible which was no less than once a month spending nearly half a day there.
I wouldn't care much (never tried them) for pellets unless I could make my own since you can't tailor your loads. 30 grns might be fine for someone and may be a compromise for me. I'll take the more accurate load as long as the velocity is good. I have made paper cartridges quite a bit and enjoy using them. Quicker than a pellet too as it's an all in one thing.
With every chronographed result I see standard Goex at the bottom of the energy level. Pyrodex RS is more energetic than 3F standard Goex by a fair margin. To be fair my interest here is concerning my revolvers as their capacity is quite limited.
When I first received my Ruger Old Army I wondered if it was useful for hunting, and if it was similar to the .45 Colt. Many forums and their patrons told me it was no more powerful than a .38 Spl and inhumane. What these people didn't know was that their powders were among the weaker ones, which is why the performance was so pathetic despite the powder charge being no less than the .45 Scofield with a conical.
Come to find out my Ruger can outdo the standard .45 Colt loads with around 500 ft/lbs of energy with a conical IF I use Swiss, Olde Eynsford (by Goex), or Triple 7.
I couldn't find Swiss locally and Olde E wasn't available then so I went with T7, which worked quite fine through my Ruger, my Remington NMA, and my Lyman rifle. I've never had an issue. But I had to try real BP and found Olde E online and tried it. Great stuff and I use it more often than T7 as it's cheaper and smokier.
My father gave me three cans of Pyrodex with the Ruger, and though it works fine and is certainly more energetic than standard Goex, I dislike the fouling it leaves, and still have some all these years later.