You are over-thinking this and imagining a problem that doesn't exist.
If you have two drives, you can set up a btrfs RAID-1 filesystem. That gives you error detection (from btrfs) and error correction (due to btrfs being configured for RAID-1 so redundant). This is the protection against bitrot you're asking for. And protection against drive failure is provided by the fact that copies of your data are on all drives in the RAID-1 array, as long as at least one drive in the array survives it will be fine.
Every block written is hashed and if an error is detected in the data on one of the drives, it will be repaired from the good copy on the other drive.
Your data will be safe unless both drives die at the same time.
This is pretty much the point of using filesystems like btrfs or ZFS...although other features like sub-volumes, snapshots, send & receive, transparent compression, etc are very nice too.
You do not need multiple copies on each drive (in fact, you'd be better off with a three drive RAID-1 array to reduce the chance of all drives in the array dying at the same time). dup is certainly NOT preferable to RAID-1, it adds some redundancy to cope with bitrot (at the cost of halving your effective storage space, as does RAID-1...combined, you'd have only a quarter of the storage) but does not help at all if your drive dies.
And you do not need to run scrub after every write. All writes are automatically synced to all drives in a RAID-1 array.
If one of the drives die, replace it ASAP - until it is replaced, there will be no redundancy of the data and no ability to correct errors. To be really safe, keep a spare drive so you can swap it in immediately (although it's debatable whether a cold-spare is better than just having a three-drive RAID-1. A cold spare will be effectively brand-new when swapped in, while a third drive in the array will suffer normal wear and tear...but will increase redundancy and improve read performance).
Note that, as with any other form of RAID or RAID-like filesystem such as btrfs, RAID is NOT A SUBSTITUTE FOR REGULAR BACKUPS.
BTW, using RAID-1 with two partitions on the same drive is a really bad idea. You still lose half of your available space and btrfs is able to both detect and correct errors because there's a redundant copy, but it doesn't protect against drive failure. And it trashes write performance because each block of data needs to be written twice to the same drive, on sectors located far from each other - the drive will be constantly thrashing, seeking from one end of the drive to another (of course, this would only be a severe problem on HDD, not with SSD or NVME drives). And you wouldn't get any read performance benefit, either as the RAID-1 wouldn't be able to spread the read load over two (or more) drives.