For the vast majority of riders, a hub motor is the obvious choice given that it generates more torque, requires no maintenance and is the more affordable option when compared to a mid-drive motor.
Mid-drive motors are best suited for technical terrain riding, such as professional mountain biking, where weight distribution becomes more important.