It does "work", but the beauty of it is subjective. Sure, if you have 10-20 devices it might work. More than that and it falls apart fast. But the reason is pretty simple - when you enable "Zero Handoff Roaming" you're making a huge compromise: 1) all UAP need to be on the same L2 network and 2) all UAP use the same channel. This doesn't work in any large scale deployment or deployment where you truly care about leveraging bandwidth via balancing clients based on channel utilization.
I've tried it (a long time ago) and yes it works. But, you will pay the price, even in your home network if you have clients doing large uploads / downloads. There's really no point since there's no logic with it either (the UAP devices don't influence handover / AP selection). If they did they could get around the limitation of being relegated to the same L2 network.
Also if you're using zero handoff you have old Ubiquiti gear (since none of the 802.11ac units ever supported it). Ubiquiti is likely moving to 802.11r to reimplement it. I wouldn't run Zero Handoff in my house with the APs I run even if it was an option (3 x UAP-AC Pro, 2 x UAP-AC Lite, 1 x UAP-N Pro).
I'm pretty sure that if you run ZHO you lose the ability to have the maximum number of SSID as well. Which is completely counterproductive from having a Ubiquiti system. I run 3 different SSID for different use cases with different security policy applied to each. One is also specifically for guests. The UniFi controller does captive portal and authentication for guests - so no having to give guests access to your entire network and you can restrict amount of time each code is valid for as well as the bandwidth a user is allocated.
$0.02.