[LF Tutorials/Courses] Texturing & 3D

Hello, i've basic knowledge in both Photoshop & 3Ds MAX

All the games i make end up looking horrible because of graphics, i don't know to make a texture from nothing, i always needs resources and they never meet my requirements.

Can you suggest some tutorials/courses/ebooks or even guide me to what to look for to end up making nice graphics on my next game?

Especially this kind of texturing, i looove the cartoon/futuristic style

I really hope you could help me in this, sorry if i'm posting in the wrong website(unity is about games, and it includes graphics, i think xD)