Attached Link: Tutorial Guide

You are looking for the wrong thing.  Brushes are only the basic starting point.  You need to learn how to create "effects".   This link will lead you to a number of effects.  You can experiment with them to learn the possibilities.  Then, start playing around with what you learn.

I can't tell you how the above image effects were created, because there are so many filters available that could to the work.   However, compositing and gradients are possibilities, along with other things.  Often more than one technique is applied to create an effect.

For future searches use the keywords "Photoshop tutorials" and you will get a wider range of tutorials available.

Best wishes as you learn to use Photoshop, and how to create wonderful art.