While I have nothing against black powder, I can think of some big reasons to avoid Pyrodex. Not counting the week old high school gym locker smell it gives off, the highly corrosive nature is another. Maybe because I lived on the left coastal foggy area, mine clumped up and became difficult to set off with time. Apart from these things, it worked pretty well. Triple 7 did indeed leave a "crud ring" that made it hard to get the next ball past and could prove dangerous if one weren't paying attention to the fact that the ball wasn't seating against the powder. You could bounce your ramrod all you wanted in my gun when this happened. Have heard that it degrades over time from a reliable source. They left some revolvers loaded for a whole year and the loads were chrono'ed at about 1/3 the normal speed. The velocity gain was pretty high when used fresh out of the can.
The one substitute that has me baffled is Black MZ. It's been removed from the market for some reason. I have heard it was just rebranded "Shockey's Gold" is one story. I wouldn't know because I never have used that stuff.
I know it looks real ugly and it clumps up. I was always able to shake it and it went back to it's regular irregular shape of granulation. The Chrono tests I ran on it showed velocity comparable to 2f Goex in loads behind heavier projectiles but a bit slower volume for volume in the smaller bores. The wide variation in velocity that I had heard about wasn't there either. I have been hesitant about using it in flintlock guns as I had one FTF with it using it "straight up". Put 5 or so grains of 3f behind it and it went bang every time but still, left a ton of fouling. When using it in my caplock guns, no FTF issues. No difficult fouling or crud ring or corrosion either.
So, having gotten way off track (as usual), I would give my vote to real black over any of the "subs" except for Black MZ. The jury is still out on 777 as I like it in revolvers and keep using it for that reason.
For flintlock guns, real black is my choice. As far as other guns, it depends on what gun I'm shooting is my answer.