There have been other PSU fan noise complaints.

See this:  Solved: XPS 8950, noisy PSU fan, #2 - Dell Community

I read that thread and their issue is different than mine.  Their issue is the thing is stupid loud.  My issue is that my computer is whisper quiet until it goes to sleep.  Then when it does that, it is 100% full blast fans in the PSU (not the graphics card and not the cooler fan).  I completely understand the purpose of variable speed fans.  What I'm saying is that there's something triggering this thing to go into full blast mode, when it goes to sleep. 

Then look at what is in the standby.  Such as when the video card actually goes into a standby condition or condition option. 

That 3080 requires at least a 750 watt power supply.  The 6700 does not require 750 watts and in fact many of the Dell OEM video card versions are lower power versions and the supplied power supply can be smaller. 

FWIW I don't use standby on my desktop. I'm not concerned about the little power consumption that's saved.  Only thing I do is "power off" the monitor at a designated time.  

I'm not sure I understand what you mean by "what is in the standby."  Can you elaborate?  

My old PC was only ever powered off to install new components, other than that it stayed on for 4 years.  All I'd do is wiggle the mouse and wake up the monitor.  Maybe that's the condition I need to select for this one.

It's just strange that it's the PSU's fans going MAX speed.  The GPU and CPU fans are unchanged.  The PC, under regular and even under moderate use, is very quiet.  When the PSU fans go max speed it is in between the fridge and vacuum cleaner in volume.  Before anyone asks, there's plenty of room for airflow.  And even with the side cover off (which does NOTHING to dampen the noise) there's no change in whether or not it does it. 

I'm just surprised.  Overall this thing is cruising along great and I'm happy, but if these fans are going to do this all of the time and there's NO aftermarket option for a PSU, I'm just going to return it and build one.

The usual reason the power supply fan speeds up is because something is drawing  a lot of power.  My suspect is the add on video card.  Did it do it before you upgraded the video card?  For testing you could reinstall the original video card and see if it does it.

Returning a PC has a limited time frame.  I don't know what the current return period is, but at one point it was less than 30 days for US customers who bought direct from Dell.  If it was purchased at a retail store such as Best Buy or Costco it is subject to their return policy.

It did it with the original graphic card as well.

but I think you’re missing what I’m saying here, it doesn’t do it during operation of the PC, it does it when the PC goes to sleep.  I can edit videos and pictures without it happening.  

there’s got to be a setting somewhere that’s making this thing scream. 

Thinking out loud.  

The noisy power supply fan issue - the power supply fan likely is either not running or running slow and not noisy during operation, as other fans cool the PC including power supply, but not in standby and it is heard.

My guess is the power supply.  See if you can get Support to replace it with the "not noisy" model.