Zando_

The 14900K is the one current gen CPU where I'd want more than a single 8 pin plugged in. What you could do is if you have a spare PCIe cable is get an adapter for that to 4 pin EPS and run that instead, that should be good enough. 
 
You need to get cables designed for the pinout of the PSU. Buying replacement cables isn't that bad, but they need to be designed for your specific PSU. 

It's a smaller heatsink than the Noctua, and under the enterprise section. So that tells me it will probably accomplish that cooling via an extremely high RPM (and thus extremely loud) fan. 
 
EDIT: Yep, that cooler is rated from 18-45.99 dBa, the Noctua is 14.8-23.6 dBa. 
Limit them to 45W (ECO Mode) or 35W in the BIOS. My ASRock B450 board has presets for 35W and IIRC down to 25W as well. 

That’s a decidedly high end system in all regards and you should have no concerns. There is always bottleneck somewhere otherwise you’d have unlimited FPS. 
 
If your 4080 is seeing 99%+ usage in games with the graphics cranked up, it would be the bottleneck and that’s good. 

Not known to have issues
 
Since these seem to be happening since day one id say defective especiailly after a win reinstall and return the device

It's a smaller heatsink than the Noctua, and under the enterprise section. So that tells me it will probably accomplish that cooling via an extremely high RPM (and thus extremely loud) fan. 
 
EDIT: Yep, that cooler is rated from 18-45.99 dBa, the Noctua is 14.8-23.6 dBa. 
Limit them to 45W (ECO Mode) or 35W in the BIOS. My ASRock B450 board has presets for 35W and IIRC down to 25W as well. 

I'd probably go with the Ryzen with the 4060. Any option you choose is gonna have trash battery life unplugged. 

Just general, if you make an array with mismatched drives it'll base the capacity off the smallest drive (the 3TB ones in your example, leaving 1TB on the 4TB drive unused). You can mix OEMs/models fine, I have a 14TB WD and Seagate drive in a mirror array and it hasn't thrown any fits. 
^^^ Yep. SATA/SAS card needs to be supported by TrueNAS. Most will be, but I wouldn't trust offbrand/no-name cheapo devices to both be compatible and work reliably. As noted, a used SAS RAID controller flashed to IT-Mode is usually cheaper than a regular HBA, thus why it's a common option. I use an LSI 9223-8i I flashed to IT-Mode myself as it was cheaper (I did need a pre-UEFI board to do this though, the flash process didn't want to work with my UEFI boards). With LSI cards you do need to verify with the seller that the photos are of the actual device you're buying, and then check the serial/authenticity sticker against (easily googleable) databases to ensure they're real, as they are commonly faked cards. Same with Intel NICs if you end up wanting a cheap 10Gb NIC in the future. 

I would personally wait for the new socket.

+1 for TrueNAS, though be sure you're using the same capacity drives (not sure what medley of old drives you're using), and be sure that the PCIe SATA card you use plays nice with ZFS. 

Then 14th gen isn't likely the best option. The 7800X3D is the better gaming CPU by a fair bit in most games, while also being cheaper (both in part cost and platform costs) and actually having an upgrade path. 
 
There's the Z790-H, Z790-F, Z790-E, Z790-A, Z790-A II, Z790-E II, Z790-F II, Z690-F, Z690-E, Z690-A, Z690-G, and all the B- series versions as well. "Strix" is just their catch-all term for all the ROG boards without the ROG OC features, and there's quite a lot of difference between each of them. There's multiple "TUF" boards as well, and "Maximus" boards as they're each different series of motherboards. 

The reason for low SSD prices in the summer and fall is that Micron overproduced on NAND. Micron has been desperately trying to correct this - it resulted in a net loss for their company at their last earnings call - and they slowed production many months ago. I think this is the likely culprit.
 
And unless Micron is lying about profitability (which would be both illegal for a public company to do and stupid to do, because losing money doesn't attract investors) this price increase is just a price correction brought on by reduced supply to let them be profitable again. Silicon manufacturers are not going to run at a loss - they aren't a charity, they're a business.

Definitely. It will not run some modern titles at all due to not supporting full DX12 features, the 3GB VRAM chokes hard in some newer titles, and they draw insane wattage (my GTX 780 Classifieds pull 350W). Driver support - outside critical security updates - is also dead, so no optimizations for new games, again making it an even worse option. They're cool retro cards but I'd really advise finding something newer if you want a decent do-it-all PC. 

I won't get a 700 series card, drivers aren't even updated since some times
A GTX780 is weaker than a 1060, that go for around $60 to $90 on Ebay, seems a better deal
 

what exact games are you planning to play on that thing?
 
specific examples are always welcome as a deciding factor.

Would be a hard no from me. Do not use it. Get your money back. 

I've been happy with TrueNAS Scale.

That's fair. 
 
I have been basing the fan speed off the CPU temp as the i9 goes to around ~87°C sustained when gaming. I never knew you could base the fan speed off coolant temp rather CPU temp. I might try that, though I don't think I have enough thermal headroom for that, but I'll still give it a shot to see. 
 
As for power, I do want to lower the power consumption of my system as a whole since my parents are the ones currently paying for the electricity, and I want to lower my power usage out of courtesy. I do find that in the winter months, my room does get a little warm when the PC is running and it does help with heating like for yours, but it might not be ideal for me during the warmer months.
 
Thanks for the info though. 
 
I might look at the non X3D chips for AM5 or I might stay with my current system for a bit longer and see how things play out.

What fans? Your AIO fans should be set based off coolant temp so they don't do that, if they're set to run off the CPU temp then they will ramp up and down obnoxiously. 
Unless power is expensive for you then the PC draw isn't really an issue. Though PCs are incredibly good at blasting that wattage out of the case as heat, so I do find with my PC that it will fight my AC on warm days, and that could measurably bump the power bill given the wattage those units draw.
 
As far as PC power itself goes, I only ever noticed a large power bill spike when running ~400W of hardware 24/7 for a full month during a folding@home event a few years back. Those happen during the winter months so it wasn't fighting my AC (in fact it actually helped my heater instead), so I do wonder what the numbers would have been like if it were summer. 

Scale is just linux underneath, it should support 5.25" DVD readers without issues.
TrueNAS Scale is just a linux distro meant for NAS usage, it still has all the support regular linux does.

Pretty much, unless you're worried about the actual power draw itself as Schnoz noted. That'd be the only real reason to up/sidegrade IMO. 

13900K adds 8 more E-cores and... that's about it. It's clocked slightly higher, and there's a bit more cache but that's likely there due to the higher core count. You'd likely see 0 benefit in games, in allcore workloads it would be quicker due to the 8 more E-cores (slower than P-cores but still, 8 cores is 8 cores). 
Every review of them I've seen cools the chip with a 280mm or 360mm AIO just fine. You can add a contact frame if you want, AFAIK they're like $20, not a big deal. 

Likely not. 7800X3D will be significantly slower in allcore render loads, about the same (within literally a couple fps) in most games, and then actually reasonably faster in games that leverage the X3D cache properly. A 7950X3D would be a better fit for what you're doing, but also more of a side-grade than an upgrade. 

Likely not. 7800X3D will be significantly slower in allcore render loads, about the same (within literally a couple fps) in most games, and then actually reasonably faster in games that leverage the X3D cache properly. A 7950X3D would be a better fit for what you're doing, but also more of a side-grade than an upgrade. 

Honestly
 
Start over. Basically everything needs an upgrade.
 
500$ is enough to get you a used 6 core 12 thread ryzen gaming pc with a rx480/580 in it EASILY. Id just browse around in local offers and ebay a bit.
 
Then ask hetr to check if stuff is good.
 
Theb once you have it post the psu here to ask if its ok because they almost never know or list what psu is in there when its important that its at least decent quality so yout rig doesnt die

Buying a graphics card just because it supports resizeable bar is indeed stupid. It is a feature that is as you said exists on all competitors. SAM isnt anything special just because amd called it smart access memory lol.