I put antiX on a 2 Gb HP 1 x core Atom a little while ago. It’s used for notetaking at meetings with LibreOffice, internet browsing through wifi. Not particularly heavy usage but it runs suprisingly well. As your hardware is a bit restricted, perhaps try that. Edit: spelling
I think I had a look at most of them except Umbrel. Bit of a mixed bag for me and none of them struck me as outstanding. On paper I fancied Runtipi but I struggled to get that up and running even with Debian 11. Liked the inbuilt proxy servers but some of the apps I tried fell over so there was that. Some of them seemed a bit of a walled garden, for instance cosmos cloud provides constellation vpn, free for now but intends to charge for it later. Having commited you might find in future that transferring your containers might be difficult because of the way that they are created to work with the specific application. I decided docker and portainer was simpler for me. On a similar journey to create NAS looked at Proxmox,Truenas Scale and OMV. I’m coming to the conclusion that they’re nice but I don’t need the level of sophistication they provide. The GUI are nice but I could build on Debian or Ubuntu for my needs, mostly containers and the odd VM.
Mate. Stick with Windows or MacOS. I don’t think Linux is for you.
I’ve seen this type of question elsewhere. Why is it an issue?
Standardisation? Corporate Linux? Just like the big boys? Big fish eat little fish.
Careful what you ask for . .
I put Antix on a 2Gb 64bit HP Atom. Worked well for notes and browsing. Oddly an SSD seemed to make little difference to performance compared to the previous HDD. Old architecture I guess.