On my youtube channel, you can find plenty of videos where we create various textures in Substance Designer and many videos about creating 3D meshes in Houdini.

Make sure to check playlists to watch game engine workflows from scratch. 

On Gumroad, you can find various noise textures we use in the tutorials. There are presentation slides I did in the past, and also you can sign up for a monthly newsletter. 

Textures are free to use in your project without giving credit if that's an issue. Don't sell them as your own.  

On Artstation, I post updates about upcoming tutorials and breakdowns of the VFX I made.

Additionally, I post my professional work on various projects.