What are the best alternatives to this smart hub?
Something that will work with door magnets and water leak sensor.
There’s no one right answer. Different things work for different people. You’ll find discussion on the topic at the following link:
The thread JD linked is a great start. You’ll find that it largely depends on the devices you’ve got (ZigBee vs Z-Wave) and what expectations you have of your destination platform.