The "commute 60 minutes to an office" culture is rather hostile to community living. As is the fact that many people aged 80 or so are alive, but not self-sufficient and need nursing.
If you get a stroke in rural Africa (or in 19th century Europe), you just die and that's it. Your descendants do not need to worry about keeping you alive but bedridden for five more years.
Of course, this will always be a deeply personal decision and there's no universal answer to this question.
I don't like this idea kids owe their parents anything simply for existing. Nobody asks to be born, and since there's no meaningful consent it would be wrong of me to impose a duty of care on my future children when they have no say in the matter. I owe them a decent childhood because I chose to bring them into existence, they don't owe me a decent old age just because of social expectations. In fact, I'd be proud of them for rejecting those expectations because grudgingly making those kind of sacrifices can only breed resentment.
You need family to look after you - children, grand children, nieces, nephews, and so on. They are the people that will truly care and advocate for you, if you become incapable.