My parents are my neighbours. It's great. One of the things I value most about how life turned out.
My kids are still young (10, 6, and 6), and my parents are in their early 60's. Barring any unforeseen circumstances, my kids will spend the majority of their childhood with nearly daily time spent with their grandparents. Similarly, a lot of end of life questions/complexities are already answered. My parents are in a home where they can age in place and we can provide care for them when their needs increase over the coming decades.
I had some reservations, if I'm being honest (it was my wife and my mom who were the primary drivers of the plan), but having spent ~2.5 years in this arrangement so far, I really wouldn't trade it for anything.