The Intel N100 is the performance of an 8th gen i5 at drastically lower power draw and includes the iGPU media engine that was included in 12th-14th gen chips. That can handle 4K media transcoding including h.265 HEVC and AV1 decoding in hardware.
I ran a 2nd gen SandyBridge monolith system with storage and services for near a decade. And that got long in the tooth and struggled to transcode.
I've moved to using TrueNAS for storage as I determined having storage on its own layer is fine as storage capacity is the bottleneck there and I can keep hardware around for longer. I keep that system as just storage using a Z-RAID2 with ZFS and some offsite replication for important data. I have a desktop backup service as a Docker app, and a VM running ProxMox Backup Server hosted on the TrueNAS as I feel those are really just storage.
I then run ProxMox on the Mini PC and have separate LXC containers for each service. If I find I need more compute I can always get an extra PC or a more powerful one and migrate the containers. I've been able to spin up new services to trial run and get rid of ones I don't like.
If things do south I can build an entirely new ProxMox host, point it at the ProxMox Backup Server and be back up and running in ~15-30 mins.