I'd divide bikes into several classes:
- Ready-made mid-drive electric bikes
- Ready-made hub-drive electric bikes + maybe a ready-made mid-drive electric bike with a mid-drive system that uses a standard bottom bracket shell (apparently those exist, as indicated in the question)
- Retrofitted hub-drive electric bikes + maybe those mid-drive retrofits that use a standard bottom bracket shell
For (1) the general advantage is that they are the best when power and controllability are considered. For example you can get 85 Nm of torque from the best units. This combined with for example 28T/38T/48T triple and 11-51 cassette means you get 155 Nm of torque at the wheel -- and this is not at zero speed, but at whatever speed you are travelling. Also, all mid-drive electric bikes that don't use a standard bottom bracket shell but rather an all-in-one mid-drive unit include torque sensor. This means that you control the drive unit by varying pedaling power. If you want to go slower, you just pedal with less effort. You don't have to adjust the assist level at all.
For (2), the problem is that these almost always lack the all-important torque sensor. Also, the strongest Bafang hub drive I found is 95 Nm and intended for fatbikes (so probably not compatible with anything else), for regular bikes the strongest is 80 Nm. I think these pale in comparison with a strong mid-drive with low gearing. Also you have to remember that for hub-drives the torque they specify is the torque at zero speed, for mid-drives they specify torque at pedaling speed. So you cannot say that for example 85 Nm mid-drive with 1:1 gearing would be equivalent to 85 Nm hub-drive.
However, (2) has a massive benefit: most likely the frame is standard. This means if an important electrical system component fails and you can't find a compatible replacement, and you have to replace all electrical parts of the bike, you can do it. However, for mid-drives this is generally not possible since there is no standardization for the mounting of the mid-drive into the frame. You may find that for example Bosch drive unit of year X might be compatible with another Bosch drive unit of year Y, but this is not guaranteed, Bosch may change the mounting as they wish from year to year and from model to model.
For (3) you get all the benefits and drawbacks of (2) with four additional drawbacks: first, you (or someone else) needs to do a lot of labor to retrofit the bike, secondly since you are not a volume buyer you don't get the discounts volume buyers get, thirdly you need to throw away lots of components and labor, for example your old spokes, your old hub, and the massive effort the wheelbuilder spent to make the hub, spokes and rim into a complete wheel. Fourthly, frames and forks have a variety of axle standards, for example if you have a thru axle frame but the motor hub you want to buy is for non thru axle frames, you have a problem. I would consider (3) only if (2) is impossible for you due to some reason.
As for tandems, firstly from your other question you said the other person is not capable of pedaling with full effort. This means the electric assist would need to be very strong. This limits your options to maybe two: (1) a very strong mid-drive unit with low enough gearing, (2) a very strong hub-drive unit. Most units can be ruled out since they are not intended for tandems where one of the person cannot pedal at full intensity. Considering that tandems are very expensive you may not want to throw away the frame if a mid-drive unit fails, thus (2) might be preferable. About the torque sensor, I always advise selecting an e-bike with torque sensor, but in the case of tandems this may not be the case. The reason being that in tandems there are two persons pedaling, so you cannot control the pedaling effort all on your own. You must communicate with the other person, and this makes the adjustment of pedaling effort very slow. This is exactly the same problem that plagues every e-bike without torque sensor: you must communicate your intentions to the computer by continuously adjusting the assist level. But since the problem with tandems and e-bikes without torque sensor is the same, adjustment of power level is very slow, the lack of torque sensor will not probably bother you.
Thus, I might consider an e-tandem with a very strong hub drive in this case. Maybe a 80 Nm Bafang hub could be adequate, even if it doesn't give the full 80 Nm at speed, since anyway you need the maximum torque only on steep hills and you are going very slow on those hills anyway.