I've only ever ridden a rear hub for a short time so no real experience of one, so I'd be interested to hear why you think mid drive 'makes sense' for off-road riding especially as so many leisure ebikes come with mid drive units,Aren't all hub motors cadence sensing which from my limited experience doesn't give the more 'natural' assist that torque sensing motors give.
With a mid motor, you can have lighter wheels so suspension works better. The central mass gives better handling. Also, you can get higher torque and lower speed. Those attributes give you an advantage when doing serious off-road riding. It's a slight advantage for normal riding on the road compared with a hub-motor, but then you have to consider the disadvantages.
With a mid motor, you have to be in the right gear all the time because it will rev out in the lower gears, which makes riding more frantic and less relaxing compared with a hub-motor that doesn't care what gear you're in, nor when you change gear. The mid motor's high torque in the low gears makes the ride jerky, and if you have to do a quick stop when in a high gear and don't get time to change down, it's difficult to get started again and it can damage your gears and chain.
The hub-motor just gives constant torque to help you pedal. It's a more comfortable ride. You can start in any gear and you can pedal as hard or easy as you choose. In the old days with crappy batteries and 36v, hill climbing was a problem, but now with 48v and higher power batteries, anybody can get the torque they need for their worst hills.
To summarise, for my rides, which are touring, commuting, shopping and generally riding around, I find hub-motors more relaxing. That's not less effort to pedal. It's not beeing lazy. It's just a smoother ride and less to do except pedalling. That's quite important too for winter commuting when you have cold hands. Weight distribution isn't important for shopping or riding on roads. Regardless of anything else, I'd always choose a hub-motor for that type of riding, because it gives a better ride, but then you add the other advantages of lower cost, lower maintenance, better reliability, lower running costs, ability to bail you out if you have a chain or gears problem and less noise, the mid motor is left a long way behind.