Linux

Not sure if this would help, but I found this channel helpful for understanding the basics and mostly avoiding wrong parts. Also he has some videos were he explains why you should choose one part over another.

Scatter volt channel

As you have in your post, Logical Increments is a good place to start.

As others have said, AMD is your best bet currently, mostly because of raw performance compared to recent Intel offerings. If you have no limited budget or power requirements, here are my recommendations:

If you have the paid version of Davinci Resolve, AMD does not have the best selection of hardware encode/decode options, but people have reported that Intel Arc GPUs work, so I would get and Intel A310 as a secondary GPU if that is something that you need.

If you want the best of the best GPU, without going Nvidia, the AMD RX 7900XTX is it. Also, AMD has stated publicly that they are moving away from high-end GPUs, so there probably won't be a better one coming out anytime soon.

If you want to plan for more gaming than you stated in your post, the Ryzen 7800X3D is the best gaming CPU on the market, so I would get that. If you plan to focus on video editing, the 9950X is the best, but probably not worth the cost compared to cheaper 9000 or 7000 chips.

If you go with a Ryzen 7000 or 9000 CPU, get DDR5-6000 CL30 memory.

If you're getting an air cooler for your CPU, don't pay more than $50. There are a ton of great, cheap options these days.

Get either the new Antec Flux Pro case (when it's available, probably this month) or the Fractal Torrent if you care about best thermals and quiet operation. Everything else is a compromise.

If you need HDMI 2.1, you'll need a DP -> HDMI adapter on an AMD GPU because of a licensing squabble.

Those are things I could think of off the top of my head. I don't think I missed anything big.

Go AM5. The 7600x3d is 300 bucks and nice

Here's a video with some good builds at different price points. That should be a decent starting point.

https://youtu.be/8tUM-miOzBA?si=BNjOJeY3Qi_HbdyV

you are getting advice that will make a good gaming pc but not a good workstation for what you said you're gonna do.

do the opposite of what most everyone in this thread is saying:

intel over amd (this could actually go either way depending on the price point), nvidia over amd, start at 32gb of ram and go up from there. prioritize cores over threads, sneak a rotational hard disk in, spend more on your power supply than you planned to.

plan on not using wayland.