I'm running Immich, syncthing (watching about 2TB in 150,000 files), jellyfin, and pihole, as well as remoting in to a browser session, on this: https://www.amazon.com/dp/B0CH81C4K3 which is a $125 NUC with 8GB of RAM and an Intel N150. I know from experience that adding NextCloud to it would work out OK for a family, and I imagine you could shove most of the rest of that list on to this system as well, though in the case of ProxMox I'm just talking about the management. Obviously I'm not running very many full VMs on that before it runs out of RAM. (I don't even know if it can run VMs. Everything's docker in this setup.) The bottleneck appears to be RAM as that is eating about half of it right now. The CPU only works when someone is doing something, and there is some contention at startup as all of the services start scanning their storage for changes, but it gets through it.
jellyfin is configured to not transcode anything. The vast bulk of my library is DVD/BluRay rips of my own creation and I just ripped them in the desired format in the first place. This could probably keep up with a single DVD-quality re-encode, I dunno about Blu-Ray (depending on config, perhaps), but I just have it serve the correct files in the first place.
There's a ~$125 5TB USB drive hanging off of it for the media storage, which syncthing syncs to another 5TB drive in the house. (I don't actually "back up" my media storage in the full sense; everything else is actually backed up in the full sense to S3 via restic.) The "contention" I mentioned above is because all the big data sets are mostly on that spinning-rust drive.
The Immich AI features worked fine on this, though it did take overnight to process my initial load of ~20 years of photos. However once it chewed through that, the responsiveness is fantastic.
If you want responsive AI that uses GPUs this isn't anywhere near enough, but for any "conventional" app, $125 or $250 buys you a lot nowadays.