There are different levels of scalability needs. CERN has over a dozen (Ceph) clusters with over 100PB of total data as of 2023:
* https://www.youtube.com/watch?v=bl6H888k51w
Certainly there are some number of folks that need more than that, but I don't there are many.
> Like Ceph it is also vulnerable to single points of failure.
The SPOF for ZFS is the host (unless you replicate, e.g., zfs send).
What is SPOF of Ceph? You can have multiple monitors, managers, and MDSes.