I own all three types of drives on my ebikes, and have dabbled with 2 wheel drive. My hub motors are all geared motors. I am not interested in direct drive motors because of their resistance to coasting/pedaling. While this is manageable on commercial bikes, DD motors for kit builders are mainly heavy (but powerful) monsters. We have one commercial bike, a geared rear drive bike and various kit bikes of different sizes from a fatbike to small folders. My mid drive is a 750W bafang BBS02, but I also have a TSDZ2 model that I've not installed yet.
For a commercial ebike, I assume that the manufacturer has managed the strength issue on front drive. I think a kit builder should simply avoid front drive. It adds an extra concern and makes front suspension more worrisome.For rising, I find that FWD can slip on wet pavement or gravel on an uphill start. In hindsight, I would not do it again.
Mid drive requires a bike riders mentality. You want to be in the right gear for starts and for hills. A stronger motor can overcome rider error, but it's not good. Commercial middrives do monitor motor temperature and shut down if the rider heats it up too much. Road bikers who average close to 20 mph claim to change their chains every 500-1000 miles, while us slower riders haven't touched a chain in decades. If you run your mid drive at 25 mph, then you should expect the same kind of chain wear. I suspect most recreational riders will never wear the chains on a Bosch or Yamaha bike at 15 mph.
Hubmotors also benefit from smart bike riding. I believe the motor is there to assist, so one still needs to be in the right gear. However, starting out from a stop only needs about 100W, so riders like my wife get away with a throttle start in a higher gear.
I think all ebikes are fun. However, features like suspension, riding position, comfortable seats and hand grips are probably more important than the type of motor, once you have something that has enough power for your needs. Weight and maneuverabilty may also be more important to you.