Please consider what we did. After our youngest son tried to kill my ex-wife, we had him picked up by the state, that diagnosed him with schizophrenia. He has remained in their care for 22 years, despite their considerable investment in his treatment. I doubt he'll ever come out of their system, but we won't know, because he's cut off all communication. So be it.
Oldest child, a daughter, was simply lazy, & it got worse & worse, until wife & I disinherited her, through the legal system. She went ballistic, but is no longer allowed in our home. She had a son out of wedlock, who has turned out to be a great kid, & we are helping him out directly, with the warning that if his mother gets anything we send, he'll be cut off, too. He's a college sophomore on full scholarship.
Middle child required the most intervention. We were paying for college, until I found out that he had only attended for the first few weeks, & was collecting our financial assistance from a friend who worked there. Got the friend arrested, & cut off our son. His wife divorced him, & left him with our 8yo granddaughter. I drove over, & picked her up, & she lived with us through her college graduation (cum laude). We forced him into the military, in lieu of staying cut off, & he did well. Crashed out a few years later, due to medical problems, but still works for them as a civilian.
So, three kids, with totally-different problems & solutions. Do we feel guilty? Not in the slightest. It's a different world from the one we grew up in, & our kids are just as likely to take advantage of us, as some thug off the street. Wife & I owned our company, so money wasn't a problem, & you sound the same way. My suggestion is to find solutions that work for YOU, then do them, & don't look back. Think out of the box, & run your ideas past your lawyer.
Oh, as far as where to live, choose a location that makes you happy, not anyone else. We now live at least 2500 miles away from kids & grandkids, so if anyone but our daughter wants to see us, they can come out here to Hawaii. Zoom, Skype, text, & email do just fine to keep us in touch, & we don't waste time on social media. You've spent your life supporting them, so retirement should be where you look out for yourself. At least your kids don't have to worry about supporting you. Good luck with wills & trusts - that's our biggest problem! We are NOT going to turn any of them into instant millionaires, when we conk off!