First of all, I do not assume any faulty end devices (my Fire Tablet is completely unremarkable in this respect)
It is not about faulty end devices but about completely normal devices as they are sold as standard today. Of course your Fire Tablet is unremarkable if you do not deal with the topic. If you currently let two different endpoints broadcast the same SSID, change one SSID and be surprised how much longer the battery of your Fire Tablet lasts. You will notice this immediately within three days.
but basically the device SHOULD switch in case of poor reception.
Of course it should be like that, but if this happens every three minutes due to signal strength that does NOT come from the access point but from the end device, it is counterproductive.
There are corresponding management solutions to enable this control, but in a single-family house I still consider the solution with one SSID to be the best if you don't want to switch manually all the time.
We agree on that. That is why I said that if a FritzBox is used, ideally also a FritzRepeater is used as an access point, because then the FB access point and the client determine to which one the client connects. But that has nothing to do with mesh Wi-Fi.
I don't quite understand why it is better to turn off the Wi-Fi of the FritzBox?
To avoid hopping between the networks. If that is not the case for you, for example because your basement ceiling dampens the basement Wi-Fi strongly enough, then it is not better to turn off the Wi-Fi of the FB but irrelevant.