> This is a huge issue for btrfs and for COW FS in general, because they have massive write amplification for small and frequent writes

Have you considered using a different fstype like XFS for this? btrfs is good for homedirs, but I wouldn't necessarily use it for other filesystems (/usr, /var, etc.)