I do not use procreate myself, but my wife does. She somewhat was underwhelmed from the 3d painting abilities (which may have it's cause in the simple fact that she uses an older ipad pro. It's probably a whole other experience with an m1 ipad pro). Do not get me wrong, procreate is an excellent, outstanding app for digital painting. Sooner or later that function will be on the same level. But as yet you can't produce a full pbr material (no normal map for example) and it misses a whole other bunch of possibilities. And as I said, my wife didn't have a good experience with it.
Photoshops 3d tools will vanish. Adobe officially announced that already a while ago.
Substance painter is somewhat the absolute gold standard for 3d painting. Nothing else compares in quality except Mari. That one exists as a free version strictly for non-commercial use. 4k textures are the maximum you can export and there are some other restrictions. Also, there isn't a mac version anymore. Still thought, I'd mention it.
And while I'm mentioning free resources only available for pc. It's not a painter app, but Materialize (
http://www.boundingboxsoftware.com/materialize/) can create textures for example just from a diffuse map. As said before, it's only for Windows, but something like that might be a good companion to procreates limited texture generating abilities, if you choose to give procreate a try.
You might want to look into Armor paint (
https://armorpaint.org) which is available for Mac as well as Windows and Linux. Meanwhile a mobile version for ipados and one for android are available, too (both with somewhat mixed reviews). It's theoretically free, but only if you compile it yourself. The compiled version does cost 18 € (probably the same in $, but I do not know). It's intended as some substance-painter-clone, far from being on the same level yet (and missing the possibilities of designer and sampler, of course).
Quixel mixer is also free. And my experience with that was frustrating. It's in my personal experience still far from being usable, although not everbody may encounter the same problems as I did. The most annoying was invisible layer controls, but a lot of others as well. It was bad on Mac, it was bad on windows. The painting in itself is far from being a good experience, there are only a few brushes (you can create them yourself, but not just import abr) and to me seemed limited on different levels. The main purpose seems to me to sell quixel stuff. You get some 600 materials for free, which sounds astonishing, but a lot of them are just color variants of another.
But well, if you're into digital painting you can't go wrong with procreate anyhow. But you also might want to give armor paint a try.