I think the problem with btrfs is that it entered the spotlight way to early. With Wayland there was time to work on a lot of the kinks before everyone started seriously switching.
On btrfs a bunch of people switched blindly and then lost data. This caused many to have a bad impression of btrfs. These days it is significantly better but because there was so much fear there is less attention paid to it and it is less widely used.
It sounds like btrfs is solid most of the time and will explode for like 1 and a thousand cases.
A few years ago left my Fedora machine at home and left for a few days on a trip. When I got back the device was powered off and when I powered it on it said no boot device. When I booted off of a USB the drive showed as unknown with no formating to speak of.
I was able to recover it and the btrfs partition as apparently the GPT table had been overwritten. To this day I have no idea what went wrong. Btrfs in general is very solid in my experience and I use it for USB devices and my Fedora machines. I have never had a issue outside if that one time it died.
Btrfs is the filesystem that is cool but also potentially explosive. I think it has a huge amount of potential and I am very tempted to move my Proxmox machines over since it doesn’t have the same limitations of ZFS