I want to add that in many places in the US it is not just the distance, but the danger and outright discouragement of walking somewhere. For example, I contemplated using a train to get to Lego Land in California from Oceanside, California. After getting off of the train I would have to walk 1.3 miles, which is only a minor inconvenience. However, after reviewing the walking route google has this qualifier: "Use caution - may involve errors or sections not suited for walking". This prompted me to review the walk using street view and I came to the conclusion that there was not a safe route.
This is just one example of something that I think should specifically be available. There are many places where walking is encouraged and convenient, but it is by no means universal.
I have no suggestions for a hub that does what you want. However, Homeassistant does all of what you want and more.
If you have a box that HA can run on, just try it. You can integrate things you would not even expect. You can get the official Zigbee usb dongle from Nabu Casa or from anywhere you choose. Then just start pulling over one device at a time getting comfortable with HA. You can add a Z-Wave dongle, a Thread dongle, and more.
With Home Assistant the best place to start is to just get it running on your network and see all the stuff it finds on its own. Then get a Zigbee dongle and start moving things over as slow as you like. This is by far the best path rather than relying on some other hub that will eventually EOL and leave you hanging again.
Automations in HA are very easy, and coming from HomeKit, they are an absolute dream to work with.
Don't wait to order something to get started with HA, just install it on whatever you have lying around or install it in a VM with VirtualBox if you have nothing else. Get used to it and then plan out how you want to go forward. If you find that you hate HA, it would be nice to know before you drop any $$$ on it.