My only observation is that when we were cruising, there were many times we wished for a bigger and/or faster dinghy. I can't really recall the time when we wished we had a smaller and slower one.
And for reference our last two Cruise as we took an 11 ft Boston whaler as our dinghy.
We had a 25 two-stroke on it the first time, and while it was fast, very fast, it was so heavy it was really a chore to get that thing on and off the boat.
The second cruise we took two smaller outboards a 3.5 two stroke and a 9.8 four stroke. We ended up using the 3.5 a lot when Iwe didn't have to go very far. The 9.8 was great for medium length trips, but would not plane the whaler with four people aboard like the 25 would.
We have upgraded for the next cruise to a 13.5 del quay Dory, (which is kind of a Boston whaler 13 knock off I guess), with the 9.8 on it. The funny thing is it actually planes better and easier with a 9.8 on it, than the 11 ft. whaler did with the same 9.8 on it.