Even if you like your family, I would be surprised if you didn't make compromises regarding noise levels during different times of day, cooking choices, having people over, etc. Not to mention cultural differences.

The above might not apply if you have a large enough space with sufficient sound proofing and multiple kitchens, but that's not the reality for most people. There are positives, but my observations suggest that the biggest factor in determining if you live in an intergenerational household is whether or not children and the parents can both afford to live in different houses.