Mid drive is certainly best for serious off roading. No doubt that you need to use the gears to help you up those ultra steep, rough inclines. However for more gentle off roading Hub and Mid are about the same and for a metaled road the hub in most cases is the better bet.
The better of the two...