It should do fine, but I would not trust eMMC storage for the long term as a primary boot, I would invest in a barebones NuC that gives you the option to install your own SSD for the boot instead of having it soldered onto the pcb.
I currently use a NUC5i7RYH that I got second hand a while back swapped into an Akasa passive cooled chassis (had to ask them to custom order a single unit at the time otherwise they need to sell some models in bulk for the cost of manufacture) running windows 11 as the host with HA running in headless mode in a virtualbox vm instance set to boot up when the NuC boots after any power loss and the UPS runs out of power.
I’m using an mbeat 7 port powered USB hub at the moment to pass my BT and Skyconnect usb’s through it and have it velcro’d to the side of my server cabinet to avoid signal reduction with everything else being wifi/network based for devices connected to it for monitoring and automation’s.
To connect to my HA instance when not home I just use the OpenVPN server on my main router (there is an option in the mobile app for the client side to bypass the VPN when connected to your wifi else you can setup a tasker config to automate toggle of the vpn based on connection state iirc).
I also have a synology NAS which I use for my camera feeds and just use the DSCam app when needing to check back the live feed though they are able to be pulled up in HA to allow my shelly button 1 doorbell automation to take a snapshot for the notification on the phone when its pressed which is nice.
I have some switch bots connected via BT for HA to control my HDMI switch and the light in the kitchen so they are all local, same with the aeotec motion sensors tied to them (also have a median entity setup for the temperature of the home for my AC unit as they have temperature sensors too) and the hue lights I am using at this time.
With the only other device currently connected via BT being the govee humidity sensor to toggle the smart plug for my dehumidifier on and off at set thresholds to help reduce mold build up in the bathroom.
So the only things I have that are and will be cloud reliant will be the air purifier that I have ordered and my tuya based lenvo smart plugs that I am going to swap at least one out for a zigbee based one when I can to automate handling restarting my NBN modem when internet goes down for more than 5min.
I have a pressure sensor pad coming that I will be tying to a leak sensor with the trigger set to bed occupancy state for some automation management and the next main projects I want to try do is figure out how I am going to automate the ceiling fan in the bathroom (may need to have a fresh line run to seperate it from the light its connected through) and a way to get mailbox notifications.
Long reply here, but wanted to share my experience with my NuC and HA overall so far and what I have going for folks like yourself as I delve deeper into the ecosystems myself.