Nickel16

You didn't mention your OC if you had one.   If your running base,  yeah you might have a problem.   If your @5Ghz,  well,  that looks like it might be normal.
 
 

@C10H13NO2 explained it

CS-Go is quite CPU intensive esp. if you want these high fps. Depending on how the map is designed, how much stuff is put into it , how many players, how many nades and gunfights are happening this can up your cpu usage. And as you know increased usage = increased temps = increased fan speed. 
The GPU is not making a huge impact in CS-Go, CPU is doing most of the work. 
Otherwise it's okay to have a high utilization, that means your cpu is working with all it got/ the game is using all its ressources. I am using AMD so idk about the temp. but as above mentioned I'd also say temps are fine. 

Normal behavior. Also normal temps in my opinion.

I agree this sounds like fan noise.  Try removing the fans one at a time and see if there is a particular culprit. 

install anti-vibration pads on the fans?

seems plausible. not personally aware of what else it could be

Noctua NH-D15 or BeQuiet Dark Rock Pro 4 are my recommendations for good air cooling

Noctua NH-D15 or BeQuiet Dark Rock Pro 4 are my recommendations for good air cooling

Not really.
 
Cooler - Higher wattage = more heat generated (when it's running at a higher load). Sometimes higher wattage units will use larger heatsinks, but they could also just use the same as the lower wattage versions. Such is the case for the Bitfenix Whisper as an example with the same heatsinks on the 450W model and 750W model which brings us in to quieter...
Quieter - Depends on the PSU and the controller for the fan... Higher wattage PSUs may be louder at higher loads because they need to run the fans faster to move more air to cool it. Then there's all the PSUs with zero-RPM/Eco/passive operation where the fans don't spin under certain temperatures and load, but again that depends on the PSU itself. No one size fits all answer to this question.
Efficiency - Doesn't make much difference, maybe 1% either way depending on the load. Nothing noticeable. Both the RMx and Whisper suggested are 80+ Gold rated.
 
For example here's the RM550x efficiency chart. Since you're in Europe you'll be on 230V which is the black line. As you see once you hit about 20% load or so efficiency plateaus with only a very slight drop in efficiency as load increases.

ftp://members.cybenetics.report/PDF_Reports/d/cybenetics_enO.pdf
 
The reason to go with a higher wattage PSU is because your components consume more power. Beyond that there's not much benefit, but there's also not much downside either besides paying more.

That PSU should be fine. If you're still running the same system you were 10 years ago then just keep it. Worst case scenario if it does fail and take other components with it you only lose 10 year old hardware which probably isn't worth a great deal anyway.
If you buy new hardware to replace your system then buy a new PSU to go with it.

It will be fine (Aorus Pro). Though the Master would be better IMHO. 
 
GB Z390 Aorus series boards are very well made, goodVRMs, fine power delivery. You can't go wrong with the Master

Are you building an entirely new PC? If so what budget/country, what do you need it for, what's your monitor resolution/refresh rate, and what is your current PC?

@Emmpii
I´d go with the Z390 Aorus Master then. Judging by the reviews and test i´ve seen about z390 boards this is a great board in terms of thermals and VRM (especially for the price)
If i remember correctly the Maximus XI hero didnt perform so well in these tests. Take a look for yourself on the HardwareUnboxed Video about z390 performance comparison.

@Turtle Rig

Ah okay. So i don´t need the exact same size? A smaller fan does fit in there aswell? 

Im thinking hes talking about the width.. My bad...... But ya no worries it will fit in the case no problem.

Not much, more voltage = less life but not drastically so at that level.

1.45 us trouble territory, anything below 1.4 has generally shown to be pretty good.

It's fine, though the silicon quality leaves much to be desired.

1.38 is not too high. If your temps are in check, it's all good 

Essentially 8 cores at 4.6 should outperform 1-2 cores at 4.9 + the rest off the cores at base clock. Almost no task now that would lead to a CPU boosting it's clocks would actually only use 1 or 2 cores. 

Ah i see. this is an interesting question. You are asking when a game requires a fast single core operation, is it better to have it at 4.9 or to operate it at a lower but albeit a multicore setting.  I hope I understood your question correctly.
 
To be very general, I think multicore is always better than a single core. No matter how fast the single core operation is, if it is within 10% of the clock speed of the other cores then it should yield a hefty boost. If you play many games that rely on single or dual core, then set the speed differently. That is completely doable in the bios. But at the same time, no modern games require a fast single core or a dual core for that matter. Most games are optimized for all the cores. I hope that helped. 

After you manually change CPU multiplier, boost clock will get deactivated.  When you set CPU Core Ration to 47, every loaded core will work at 4.7Ghz regardless of the load.

I have the pro mobo and my 9900k is at 5.1ghz with good temps, but that’s silicon lottery. But imo the pro will do the job for you 

some do, some don't, it's hard to say