My in laws and parents did this so I say NO WAY!
My in laws were about 250 miles away in a 2 bed bungalow - 3 children 2 dogs all expected to come for special occasions and bunk up overnight in the living room etc. 4/5 hour drive each way, whole weekend taken up with packing, driving etc and then no sleep when you got there. You have to have a fantastic relationship with all of your children and their partners to make it work - once all the children partnered up there were 8 of us with one toilet - it was bluddy awful. Then they'd give the big guilt trip - don't leave it so long next time etc.
My own parents, who watched this play out for 10 years then decided to move 350 miles away - 4 hours minimum - another 2 bed place.
We just about managed when we all lived near but once you threw in planning, weekends spent travelling - travel costs, distance physically and emotionally things fell apart.
My Mum and Dad live so far away you can't do it for a weekend - you need time off work too. I work full time with 20 days holiday - hard to commit to using that time.
Lockdown has been a nightmare for them. We can't do their shopping or pop in or go for a walk with them or anything - I've not seen my mum and dad since 18th October 2019 - and won't be seeing them any time soon. I'm facing the fact that at their ages we might never see them again.
When my Mum had a stroke there was nothing I could do to help - just trying to do her power of attorney was a nightmare with posting back and forth.
It doesn't help that my daughter is in a wheelchair and we can't even get her into their garden yet alone their house.
They have two children, two grandchildren and three great grandchildren that they almost never see.... but they claim family is everything to them.
I swear I won't put my daughter/grandchildren through it. It just makes things so unbelievably difficult.
God knows what will happen when one of them dies - at the moment I don't even know how we could get to their funeral as we can't stop in their house with daughter etc... a fucking nightmare is what I call it...
... but hey they live by the sea in a really pretty area and say it's the "best thing they've ever done" so what do I know!