I use black powder and substitutes in cowboy action competition and during deer muzzleloading season. I am not interested in setting velocity and energy records with my black powder guns. My load for deer in my .54 Hawken is 80 grains of powder under a patched round ball...It gives me excellent accuracy and will still go through a deer. Max loads for a .54 are around 120 grains, so I am well below maximum when hunting. The deer don't care.
For competition, I like Pyrodex in cartridges (.38 Special, .45 Colt) because it produces less fouling (IMO) than Goex and is cheaper than 777.
I like Schuetzen real BP in my percussion revolvers because it ignites more easily with a percussion cap than Pyrodex, it's cleaner than Goex, and it's cheaper than 777.
Just about any BP or substitute works in a shotshell at cowboy action competition.
So I am presently using up my remaining Goex inventory in shotshells, Pyrodex in cartridges, and Schuetzen in the cap and ball revolvers.
I do not plan on ever buying Goex again. I have loaded all three (brass cartridges, shotshells, and cap and ball revolvers) with 777 and it worked fine. It's just more expensive than the others and I have no need for a hot black powder substitute. If I found 777 at the same price as Schuetzen or Pyrodex I would snap it up. But so far I haven't.
You will hear complaints about Pyrodex being corrosive. I cover the exposed parts of my guns with a light grease before shooting, and clean them a few hours after shooting, and do not have a problem with rust or corrosion. If you do not like cleaning your firearms thoroughly, avoid Pyrodex.