I don't get, none of it.
I'm fine with lower RPM, SMR externals for backups. So what if it takes longer? Backups happen in the background, it's not a deterrent to me at all to make them based on amount of time, especially when it can be automated so it's not like I'm babysitting it to start and stop.
What is more important is lower cost per capacity so I can have redundancy. I consider the cost of (redundant) storage space for backups, more of a deterrent to most people. They say "back up your data" but less often then say "make REDUNDANT backups".
SSDs are fine for small amounts of data but are still around 5X the price:capacity once talking about a few TB.
USB flash drives aren't any less reliable if you don't have a dodgy USB setup or pick flimsy flash drives. I'm been making smaller backup sets with USB flash drives for well over a decade and have not lost a single bit, BUT... REDUNDANCY anyway!
Even with the cheaper lower end flash drives, if they are built rugged, yes they are slow but as mentioned above, it doesn't really matter if it doesn't impact the user experience. One of my two redundant USB flash drives that I make backups to weekly, is pretty slow, but it just does not matter. I plug it in, the backup happens, and later I unplug it. This requires no further attention or effort or detriment than if the backup was made to an SSD writing 50X faster.
On the other hand, cheaper (especially) USB flash drives need their data refreshed every several (less than a decade depending on # of write cycles) # of years, but there is no way that I would trust data sitting longer than that on an SSD or HDD either without refreshing it, so it comes back to price per capacity needed, including redundancy.
What is "good enough" performance? To me it means, the job is done before you'd otherwise power down the system or have to make a separate trip to the system to disconnect the backup device, if you happen to live in a mansion filled with evil spirits where trekking to this location is an arduous journey.
So many choices today make backups easier than ever, yet reinventing the wheel is a problem? I still don't get it.
I only consider performance an issue if it is running the OS, or is running games where game level load time is just bad if not on an SSD. Okay there is video editing and other apps where the user is left waiting on storage to provide the next input too, but backups just isn't one of them.
It was different a long time ago, I recall a period I was using Powerquest Driveimage, where I'd boot to DOS to make an OS partition backup to a slow HDD and the system would be unusable for near a half hour. Those days are long gone.