Hi all. Got a bit of a conundrum and im hoping you guys can give me some insight as to which direction to head in.

I currently have a HP Prodesk MiniPC with 8GB laptop style RAM and a new 1TB NVME SSD which runs 2 vms - one is a file server for all our cherished memories and important documents, the other runs a windows 10 vm with veeam community edition and plex/jellyfin. HyperV server runs on a 128GB SATA SSD with some ISOs on for vm deployment. This also backs up any Veeam repositories to Hetzner for offsite backup.

I then have an enterprise class server - HP ML310e with a P420i RAID controller and 24GB ECC RAM. HyperV runs on the 2x RAID1 1TB unknown age drives and this also stores ISOs for deploying new servers. I then have 2x 4TB 7 year old WDRed drives in RAID1 which stores the backups from the MiniPC as well as all the multimedia for plex/jellyfin. There is also a Pihole VM.

I recently stopped gaming so I now have a watercooled 8700K PC with 32GB DDR4, 1TB NVME, 128GB SSD and 2TB SATA spinning rust with lots of expansion options via SATA/PCIExpress. I have deployed HyperV server onto the 128GB SSD and currently running Nextcloud and Mealie.

Now you have an idea of my current infrastructure - obviously there is no drive redundancy on either the desktop nor the MiniPC. The enterprise server is getting fairly old now, I'm expecting drive failure at some point, the supremely hot RAID controller battery has failed and frankly it uses a lot of power compared to my desktop.

So, my idea is to retire the enterprise server in favour of running everything on my desktop PC going forwards. My problem lies with RAID. What is the best method of achieving this? My plan is to run some PCIE cards to allow multiple NVME drives so I can have the fast SSDs but with redundancy and then buy some new high capacity spinning drives to backup to and then send to Hetzner offsite as well as the mini PC so theres 3 copies of it, with one offsite. I've read about ZFS but I have absolutely 0 experience with this as all my server dealings have been enterprise hardware RAID.

I know that was long but I appreciate your time and efforts to help.

TLDR I guess: Want to retire old enterprise server in favour of newer desktop hardware - need RAID solutions for SSDS and spinning disks (both NVME and SATA).

Thanks!