While my current rig is amazing, rocking the following specs, I always dream of having a bleeding edge NVIDIA RTX Card (gaming + video editing) or high-end Quadro card (video editing)....
Every rig I've ever made, ended up becoming a home server when I chose to upgrade. My old workstation is now my Home Server NAS (named it "Rogue"): https://pcpartpicker...ic/saved/XPMPnQ
My current workstation that I use for Gaming, Productivity, Photo/Video Editing, and more: https://pcpartpicker...ic/saved/YVDV6h
However, my new dream (wishful thinking) rig is to be a fully-featured, balls-to-the-wall virtualized beast with hardware passthrough to virtual machines and a whack-ton of storage for all my video editing and backup purposes:
DUAL AMD EPYC 7773X (64 Cores / 128 Threads @ 2.1GHz - 3.4GHz boost + Overclocked to 4GHz -/- 128 Cores / 256 Threads total)
1024GB (16x64GB Supermicro ECC DDR4-2666MHz 16X MEM-DR464L-HL03-LR26)
GIGABYTE MZ72-HB2 (2x 10Gb/s ports plus a 1Gb/s remote management/IPMI port, 3x SlimSAS (total of 12 total SATAIII 6Gb/s ports) and 2x SlimSAS (total of 2 NVMe PCIe Gen4 x4)
PCI CARD #1:
Sound Card (model undetermined at the moment)
PCI CARD #2:
NVIDIA RTX 3090Ti (PCI Passthrough to a Virtual Machine for Gaming / Video Editing)
PCI CARD #3:
NVIDIA QUADRO RTX 4000 (PCI Passthrough to a Virtual Machine for Video Editing and PLEX/Jellyfin Transcoding)
PCI CARD #4:
Adaptec SMARTHBA 2200-16i or 2200-32i (for connecting the NVMe SSDs and HDDs to the system
SAMSUNG 960GB Enterprise Grade 983 DCT (no redundancy)
2x KIOXIA CD6 (KCD61LUL15T3) Read-Intensive 15.36TB 2.5" Gen4 x4 NVMe U.2 SSD (Read 5,500MB/s, Write 4,000MB/s) -/- ZFS Mirrored
4x KIOXIA CM6-V (KCM61VUL12T8) Multi-Use 12.8TB 2.5" Gen4 x4 NVMe U.2 SSD (Read 4,000MB/s, Write 6,900MB/s) -/- ZFS Mirrored Stripe
18x Western Digital Ultrastar DC HD550 Data Center Grade HDD (WUH721816ALE6L4) -/- RAW Storage = 288TB, Usable Storage after ZFS RAIDZ2 = 256TB (two drive redundancy) -/- (10-Year Warranty I get from my employer)
BE QUIET! Dark Power Pro 12 1500W (BN647) Fully Modular ATX Fully Digital Modular
I haven't decided on a case yet, but I plan for it to be a 4U Server Chassis capable of holding 24+ 3.5" HDD Bays.
After reading all of that, you must be thinking this endeavor will cost a TON of money... And while, yes it does, I could probably recoup the ROI in a few months of freelance work.