The nice thing about btrfs vs ZFS is that you can just use it like a normal filesystem ignoring all the advanced features and still get the benefit of checksumming (plus duplicated metadata by default on spinning disks) and compression
The problem with btrfs and cow in general is poor performance for databases and overall, in some cases significantly, slower performance than ext4. ZFS has high memory requirements.
If your use case mainly revolves around the benefits of snapshots then it definitely makes sense.
