I got a mini PC the beginning of this year and I have a bunch of stuff running on it now, in Proxmox. It's been a lot of complicated learning, but I've had fun.
Good question. HA Green looks pretty cool. With that processor, though, running something like Frigate might not work very well.
For me, I run HA on a normal computer that I turned into a "server". Home Assistant was a gateway drug and now I run all sorts of other stuff in addition to it. I use Proxmox (as described in the article) so HA is a virtual machine, and there's a Debian virtual machine with a bunch of Docker stuff going. Having Docker run in a VM makes backups much easier.
For HA alone, the Green looks pretty cool. Most people probably won't outgrown it, but I certainly have.