I have both a pedal drive with instant reverse (Seastream Angler) and a motor drive (Autopilot 120) and I can make a case for both of them and none of them.
1. With the pedal drive I felt more connected to the lake and to nature. Holding position by jogging the pedals and bumping the rudder became intuitive in no time. I could cover a lot of water at 2.5 - 2.9 mph. But in the southern heat it was brutal out there in the warm months. I was either completely spent and on the verge of heat exhaustion or I simply chose not to fish as much. Weight limitations forced me to make choices. I trailered this kayak.
2. The Autopilot with spot lock was an immediate game changer. But it was a beast to load and unload until I was smart enough to add a winch to my trailer. Now I am quickly in and out of the water. Absolute game changer. My pedal drive was stable, but this is levels above that. This is important not only for standing, but also with big boats and rough weather on bigger lakes. Spot lock can be both friend and foe. You have to plan your attack angles with wind and currents. Shifting winds can drive you nuts. With my moisture wicking pants and shirts, hot weather is no issue because the motor gets me where I want to go. But with the motor up front, weeds can be problematic even with a weedless prop. Lakes like Guntersville and Toho took a lot of patience with their heavy weeds. On the flip side, I can carry a ton of gear, batteries, and electronics. The only real issue is speed. With a tournament setup I max out at about 3.3 mph. My competitors with the rear mount motors go 5 - 8 mph meaning they can cover a lot more water. Another downside with that front mount motor is that it’s not suitable for river fishing. That’s why I still have my pedal drive.
I’m not about to get rid of my Autopilot, but if I had to do it all over again I would buy a 12-14 foot pedal drive kayak that was also purpose built to add a fast, rear mount motor. I would sacrifice the spot lock for the extra speed and use the pedal drive and/or an anchor system or Power Poles to hold position.
And before you think about adding a motor to a kayak, make sure you understand how it mounts, if it will cut down on your cargo area, how you will run the wiring, how much or how many batteries you need, where you can place those batteries, and how they will impact stability, center of gravity, and tracking.