Looking for feedback/recommendations for my planned server upgrade/consolidation

[HomebrewDotNet]

Hey All

I've been planning to upgrade/consolidate my current homelab setup and I'm looking for some feedback/recommendations.

Here's my current server setup + storage layouts:

'Warehouse' Truenas Scale server:
Case: Fractal Design Define 7 XL Dark Tempered Glass
Motherboard: ASRock B550 Taichi
Cpu: 4650G
Cpu cooler: Noctua NH-L9a-AM4
Ram: Kingston 128GB (4x32GB) DDR4 32GB 3200 ECC KSM32ED8/32HC
PSU: Corsair RM750
HBA: LSI SAS 9207-8i modded with Noctua NF-A4x10 PWM fan

Current Storage layout:
Boot pool:
1 Mirror vdev WD Blue SSD 250GB 2x

'Data' pool:
1 RAIDz2 vdev Seagate HDD 3.5 EXOS X18 18TB 5x
SLOG: Intel D3-S4520 Series SSD 480GB
L2ARC: WD Red SN700 NVME 1TB

'SwiftData' pool:
1 Mirror vdev WD Red SA500 2TB 2x

This server's main purpose is being a NAS and running a vm with light weight docker containers.

'Hive' Proxmox server:
Case: Fractal Design Define 7 Dark Tempered Glass
Motherboard: Gigabyte Aorus B550 Master
Cpu: 4750G
Cpu cooler: Noctua NH-L9a-AM4
Ram: Kingston FURY Beast 128GB (4x32GB) 3200MHz DDR4 CL16
PSU: Corsair RM750
PCIE Cards:
- ASRock Intel Arc A380 Challenger ITX OC 6GB GDDR6
- Nvidia Quadro P400

Current Storage layout:
Boot pool (zfs):
1 Mirror vdev WD Blue SSD 250GB 2x

'SwiftData' pool (zfs):
1 Mirror vdev WD Red SA500 2TB 2x

'FastData' pool (zfs):
1 Mirror vdev Samsung 970 EVO Plus NVME 1TB 2x

'FastCache' pool (lvm):
1 Samsung 970 EVO PRO 1TB

'Backup' disks (passthrough to Truenas vm):
1 Mirror Seagate IronWolf 4TB 2x

This server's main purpose is hosting vm's and docker containers that require more cpu power.

'Warehouse' Truenas Scale server upgrade:
Case: Fractal Design Define 7 XL Dark Tempered Glass
Motherboard: Supermicro H12SSL-NT
CPU: AMD Epyc 7443p
CPU Cooler: Noctua NH-U14S TR4-SP3
RAM: Samsung 256GB (8x32GB) 3200MHz DDR4 PC4-3200AA (ebay)
PSU: Seasonic Prime TX-850
PCIE Cards:
- ASUS HYPER M.2 X16 GEN 4 CARD
- ASRock Intel Arc A380 Challenger ITX OC 6GB GDDR6
- Nvidia Quadro P400
- LSI SAS 9207-8i modded with Noctua NF-A4x10 PWM fan (HDDs)
- LSI SAS 9207-8i modded with Noctua NF-A4x10 PWM fan (SSDs)

Storage layout:
Boot pool:
1 Mirror vdev WD Blue SSD 250GB 2x

'Data' pool:
1 RAIDz2 vdev Seagate HDD 3.5 EXOS X18 18TB 5x
SLOG: Intel D3-S4520 Series SSD 480GB
METADATA: 1 Triple mirror vdev WD Red SA500 2TB 3x

'FastData' pool:
2 Mirror vdevs WD RED SN700 NVME 1TB x4

This build will basically be a merge of the 2 servers.
My main workloads currently are
- Hosting of media center (arr stack)
- Misc container hosting (Adblock Dns, Lan caching, vpn, password manager, nextcloud, ...)
- CI/CD pipelines for my open source projects (expect to extend this further in the future as I finish more projects)
- Game server hosting (will probaably increase this in the future as well)
- Windows VM for development
- Windows vm for server management

So what do you guys think?
What I'm mainly concerned about is the cpu choice for this build. I went with a 24 core Milan due to the cpu score when comparing benchmarks to Rome cpu's.
In the same price bracket I can get 48,64 core Rome cpus but they use a little more power, are a bit more expensive and only score a little better.
So I'm note sure if I should got for more single core power or more multi threaded power considering my workloads.

Power consumption is another concern.
Currently I'm using about 250w and I would like to stay around this. (Can be higher during peak load)

Curious to see what you guys think!