3D viewport work is better on intel in most of the programs since they prefer single core power, not sure on the engineering ones. In fact, if you use 8 cores, they don't usually get to more than 75% because multi threading is bad. Cpu rendering is better on AMD because it has more cores, but gpu's perform even better than any cpu, so...
About video rendering there are some programs that have some boost depending on the codec and shit like that with intel above amd, but if you are rendering the video while you're playing (for example) amd should perform better.
I mean, if you need to stream, play and encode at same time, amd is gonna be better, if you only play and nothing else, intel is gonna perform better, at least for now because 9700k without multi threading looks like is gonna underperform on the future, but who knows.
About CSGO, it works a little better on AMD, but with a 9900k you have more than 550fps, so who cares if AMD have 20fps more. Even with quad cores that have almost 10 years you can achieve more than 100fps, so it's a bit of nonsense to buy a new pc just for csgo, unless you have a shit pc.