Choosing a Zigbee/Z-Wave hub for 50 devices: Hubitat C-8 or Homey Pro?

I would like to point out that I am new to IoT. I need to create an installation for at least 50 devices. I am currently trying to choose a hub. Ideally, I would like it to support Zigbee and Z-Wave devices. I have been looking at devices such as the Hubitat C-8, Homey Pro, Aeotec. Unfortunately, reading various reviews, I am not able to deduce anything sensible because there is a lot of marketing there.

I care that:
- the operation of the devices would be stable, and I would not have to reset it once a day
- I would like to be able to access via the Internet, but at the same time, I would not like the hub to be only dependent on the cloud (it stops working when there is an Internet outage, or the manufacturer closes support and the system also crashes)
- I would like the hub to give the possibility of large configuration (imposing many conditions and schemes) but that it would also be fairly intuitive (so that you can add and configure devices through a simple search and easy entry of conditions and not writing 100 lines of code as in assembler)

If it comes to the hub, I have no budget constraints, I can spend, for example, 2000PLN ... but I would not like it to be like in Fibaro that later the individual devices added to the system cost several times more than the competition.

Example Hubitat C-8 looks nice in terms of features, but I read many reviews that it takes years to configure, manually add drivers and lines of code, and configuring the system takes a lot of time.

Thank you in advance for tips.

Or maybe Home Assistant installed on the Raspberry PI?

What are the devices, what functionality are they supposed to have, etc.?
Most can be based on an alarm system.

Ok. I understand. But he wants to have the alarm system separately.... I would like to do it on one of the devices I wrote about.

And have you considered using Home Assistant + MQTT+ Zigbee2Mqtt? The gateways (professionally: coordinators) are made by Sonoff, for example. See the description here: Link . In Zigbee, there is no problem with the number of devices, because every mains-powered device is a router. Of course, the coordinator can be one too. For Z-wave there is also a converter to MQTT: Link . More importantly, devices on WiFi also get along with MQTT. So you can integrate equipment over Ethernet, WiFi, ZigBee, Z-Wave.

I have already purchased a Raspberry Pi 5 + Zooz ZST10 Z-Wave Stick + SkyConnect, so I can now add Zigbee + Z-Wave devices.
I don't know anything about MQTT. What would be the advantage of this solution?

If the Raspberry Pi has WiFi and there is HA on it, will it not detect my WiFi devices?
.

The HA used to connect to Zigbee via MQTT and Zigbee2MQTT (Z2M). This option is available all the time. Now, however, HA can connect directly to Zigbee devices.
I actually prefer MQTT separately and even outside of HA. Such MQTT collects and distributes messages. On the one hand, it can collect them from e.g. Zigbee devices (via Z2M) and send them to other interested parties e.g. HA. In such an arrangement, the MQTT broker is independent of the HA and we can do automation in a completely different technology. For example, I did the automation in PHP: Link .

Thanks a lot for the reply and the link to the PHP integration. Super job! I'll analyze it for myself )

Before analysing the article, it is essential to familiarise yourself with MQTT. You need to understand what it is all about. Here are the links: Link (for starters) , Link (a bit more information) .