First, there are some people that you really shouldn't be in tight spaces with overnight. Either it's because of the combination of their emotional state, love of the water or their comfort with sailing, weather conditions, tolerance of being closed-in, etc.,
Secondly, I think you need to think about what they will make them happy in the circumstances that they bring, the weather offers, and that you have the emotional ability to deliver. You have to think about what will (or can) make them happy. (e.g., you may love the isolated anchorage -- and they may feel bored stiff; or, you may like a fast, rail in the water ride -- and they may find it teriffying, etc.).
Thirdly, especially on overnights, you need to understand that people need their "space". On any "normal" boat, that's not just a function of the berth or time in a head -- it's part of the arrangements of interactions. Different people have different (and changing) needs for 'personal space'.
Finally, it's understanding when people want to talk or be attended to -- or left alone. There are low-, medium-, and high maintanence people. For some of us, just being quiet and letting us enjoy the situation around us is better than "talking all the time" -- but for others, they view that as unfriendly.
IN SHORT -- you have to be prepared to tailor your actions, interactions, plans, verbal and non-verbal communications to attempt to make others happy. If you do that (or can, due to the circumstances or your capacity) then you'll probably be more successful in providing an enjoyable "trip". If you can't, then the guests will either enjoy it OR they won't.