Hardware recommendation

How above is wrong? Does openhabian do anything to prevent mysql or postgresql from eating SD card alive? If you recommend moving storage out of SD card to i.e. SSD or USB then the reference setup is just gone and gets closer to traditional PC. I had a look at zram scripts you have, only one database supported there is influxdb. It simply leaves a whole set of other databases available via OS packages and openHAB integrations uncovered.
I get that you can’t support all use cases in software with limited hardware, however claiming that your reference setup covers majority of use cases and then adding support for external disks etc. contradicts a concept of reference setup based on SD card. Support you have in openhabian for SSD/USB drives exists there for a reason. This brings me back to my initial statement - that any system with onboard flash or traditional SSD drive will serve you better than raspberry with SD card.

That’s problem you can avoid by building a proper operating system image. Making it by scripts, as it is done now, without explicit control of what comes in will always be a gambling. I understand and value state of art built over past years, which is ok for demo or storage-less use cases. I keep going back that problem zram attempts to solve is SD card wearing at the cost of extra CPU load. You don’t need to make such sacrifices if you accept a fact, that there are better storage options than SD cards.
Performance of RPi 3 class device (with 2 or 4 core) with stable storage is sufficient to run most of home automation/small automation systems for sure.

May I ask what entitles you for speaking of majority of this community? A moderator badge, ego or a poll you performed where people marked “I like to recover my system from backup more than do not recover it at all”? I tend to reflect my own opinions without claiming they are valid for entire, major or even minor part of this community. I recommend you to do same unless you are able to measure and prove your statements with numbers. If you don’t then its just your own opinion, equal to mine.
A basic fact that openhabian is being used by this community doesn’t mean they favor MTTR over MTBF. They simply might not have any other choice.
The 2019’s community survey, showed up that RPi was responsible about 55% of setups. Such number made it large, but not the only one hardware platform. Desktop and embedded PCs accounted for 27% of setups, getting a second place.

How openhabian on rpi is holistic, if you need to fire it again, after first boot to move storage to other disk? Rest of that sentence is your own reasoning, definitely not mine background or intention.

I try, and I hope that I partially do, prove that insisting on getting RPi and its SD card a reliable is a nice exercise, however it should not be recommended for everyone, definitely not for ones who value stable and hassle free operations. You keep mentioning various options in order to improve reliability of reference setup, which proves that this reference setup is not reliable by default. After all, how much extra hardware do I need to get to make holistic approach (you claim) to be possible on RPi, to happen?

Great t hat you have a SD card mirrorning, but RPi have just one SD card slot by default, does it mean we need some other piece of storage? How well the mirroring will work with small or almost fully packed SD cards? Each write you do on SD card impacts its lifetime.
Again, I don’t know why you keep mentioning data centers.

If you look at PCs they are standardized better than ARM based solutions. The UEFI which is very common these days unifies access and enumeration of hardware. Its much easier for Linux to detect hardware your system have under UEFI than under RPi. I used single OS image on all PCs I had in my hands, thus what you claim to be an issue - is not. Its much more difficult to bake a working linux device tree for ARM than to break UEFI based system. You can move disk from one computer to other and nowadays linux will still boot from it. Unless you expect nvidia graphic or audio cards to work, many PCs out there will work.
Like-hood of broken operating system update is by all means larger with SD cards and its wearing than with SSD/eMMC storage. The way in which openhabian controls operating system gives you no guarantees at all, so PC based approach is no better or worse than that.
A proper, and safe way, to handle operating system updates involve two system partitions I mentioned earlier. You boot from A but update B and try to boot from B, if boot fails, you get back to A, if it succeeds you mark B as default and wait until next update to override contents of A partition.

The openhabian-tools, which trigger some package updates shall work with bare debian/ubuntu. I see no reason why anyone would want to mess with RPi boot config under UEFI.

There are certain components (i.e. CAN related) which were difficult to get back in 2021, there were specific ARM cpus from recent generations which were hard to get (i.MX8). I said in my earlier answers to you, that any system which have option to use traditional disk or embedded flash is better than RPi. I do not insist on any specific hardware here, but hardware with a stable storage.

I agree that standardization is important, however there is no single standard for home automation, thus there is no single hardware which can mark a standard. Since openHAB is software solution making its own standard way to connect various hardware/software, making any hard assumptions on which hardware solution is reference one, is short minded, especially if it involves unreliable storage.
Since I haven’t seen electronics and automotive industry deploying RPi or systems booted from SD cards its safe to ignore later part of above paragraph.