Our mother in law is staying with us due to the unexpected passing of her husband, and we have been experiencing this first hand as we look for a shared home.
Not only is there no multi-gen homes in our area (exurb an hour away from a major city) but it's difficult to find a layout where a part of the house can be a mini apartment or her own personal area. It seems like more basements are finished now and some of the design decisions have been quite odd to say the least.
Worst of all is that we're not allowed to buy some land and throw a small structure or trailer/rv on it for her. Even though it's for family it's not allowed as it could be rented out in the future.
The entire process has been stressful and aggravating, and is made worse by everyone sharing the same space working and going to school.