If your going to do 3d, your going to be sitting fore long periods of time. Take breaks, walk around, get some water. And get something for your body.

Some good sites and youtube channels for Computers, the best parts, and trends Look for the following.

Jay z Youtuber

z

Beginner

Intro to rigging

Inspiration

Opening shot of asteroids, (can now be done with geometry nodes and a system with 128gigs of ram. :) )

Real asteroids from Nasa

Ever see those concept art pictures of sci fi spaceships that were done in oil painting. (Syd Mead)  This persons technique is close to that style with a simple texture.  The thing that made me say wow that's awesome was that he uses a texture in color and alpha and a uv map to make those edge detail.