Have seen many guns that were ruined by Pyrodex.
I submit that the guns weren't ruined by the powder, rather the lazy owner.
I've been using pyrodex for many years, more cost effective and I can actually buy it locally which is amazing. I don't know that black powder is available anywhere in Texas over the counter now that the Sportsman's Warehouse has gone belly up in San Antonio. I ain't drivin' 700 miles to Lubbock or something for BP. Pyrodex works just fine and it's cost effective.
I clean my guns soon as I get home (about a 10 minute drive from the range, 30 minutes from my hunting property) with soapy hot water, dry out, swab with bore butter, and put up. I don't have problems with rust. The gun has a chrome bore which probably helps a bit, too. My ROA isn't chrome bore, though, and it's held up well. Cleaning is the key. I mean, even if you're camping 50 miles from the nearest building, how hard is it to take along a jug of water for base camp? If you fire the gun while spike camping, it don't take THAT much water to clean the thing out and desolve the salts. There weren't many water wells available to the mountain men. I'm sure they had their share of rusty guns, but they got along.
I can keep my gun's accuracy by swabbing the bore about every 3 shots, though I do it every other shot. I can recall BP being VERY filthy compared to Pyrodex, tying up my old Navy replica in less than 50 rounds with goo. Pyrodex will tie it up, too, though, just a few more shots to do it. Not a lot of difference between the two in any way far as I can tell. Still have to clean the gun, still have to deal with fouling. Pyrodex gets it done and I can actually buy it, so it's what I use. I may be making my own black powder in the future, too, though, depending on politics.
I just don't see black powder offering anything over pyrodex that is worth the hassles. I mean, if you want clean, buy a Remington in .30-06.
After a little bout with "Jim Shockey's Gold" APP substitute, I'm back to Pyrodex. APP sux. It might be non-corrosive, but it's also inaccurate and worthless IMHO. Pyrodex actually works as well as BP IMHO.