Many campgrounds have cabins, so plan your family trips accordingly and have your occasional guests just rent a cabin, while you congregate at the RV, and get an RV based on "your needs" for the majority of the time you will be traveling.
A bit of separation at the beginning and end of the day can be nice....... Last year we "avoided" the multi family home rental at the beach, and stayed a few miles away in our MH. It was so nice to get away from the daily, 7x24, never ending mayhem of 3 or 4 families and kids crammed into a house.
We got up when we wanted to and have my morning coffee in peace, had the "excuse" to drive back to the RV earlier in the evening and get to bed at a reasonable hour, then head over to the family house when we felt like it. It made the beach week so much more enjoyable!
2015 Tiffin Allegro 31SA, 24k chassis
2015 Jeep Cherokee Trailhawk