We hired a large 6 berth cruiser last June from Laggan.
We were at Drumnadrochit when the wind began to blow with a reasonably large swell in the water and some white tops to the waves. Our boat was taking quite a beating as it slapped onto the waves rather than cut through them making it very uncomfortable with items falling to the floor in the galley.
We turned back, going with the wind this time and returned to Drumnadrochit for another night.
Just an example of how the weather can quickly change.
I imagine it will be difficult to find a type of craft that will meet all your wishes in one.