Most of these units don’t need (or have) a fan (except for the ones with like an Nvidia quadro in them, but those I keep in my rack for other purposes, like tdarr and work stuff)
Plenty of power for proxmox, containers, whatever. Intel QSV is fantastic for Jellyfin and Plex transcoding, I’d say 7th Gen and up is plenty for most people.
Really any of these little units are well worth it. I’ve got some older ones (4th-6th Gen Intel) doing other duties, like being testbeds, managing backup storage, etc.