The be quiet is not a bad PSUI but its based on old topology that is Active Clamp Reset Forward topology that has some hard switching that can cause transformer noise under high slew loads. Nothing you can do about it except buying a better PSU also it doesnt perfom well in transient loads , it isnt optimal but its not unsafe
personally wouldn't use such an old topology with a gpu like yours
the coil whine ( specially that its that loud ) should be from the PSU not the GPU , your gpu loads are inducing it yes during gaming , but the noise itself should be from the PSU , can you confirm this ? if its from the PSU then your only option is to get something with a full/half bridge + llc topology , something like the corsair RMx or seasonic focus plus gx