> While it's true this seems like a strong US thing, I haven't heard many happy long-term stories of folks living intergenerationally.

That's really depressing. I'm sorry your social circle has such poor family dynamics. The majority of inter-generational families I know quite like the arrangement. Grandparents love having grand kids around, parents enjoy the extra help of the grandparents, meals are a lot more fun, etc.