Here's a simple blender file with a procedural shader built for creating/exporting brush alpha textures you can use in apps like Photoshop, Substance Painter, Zbrush, Procreate, etc. This was made in Blender 3.6 and should work in newer versions.
It's pretty flexible and fun to use. Feel free to modify and use this in your projects however you see fit!