That works for one generation, maybe two, but it doesn't take much to dilute the wealth. Start splitting it between multiple kids, bad investments, failed marriages, LTC, etc and soon enough, the big plans whittle down to a nice letter. My wifes grandmother left her some money (and iirc our kids too) but as she had no money (my wifes parents had been propping her up for years living in LTC), there were no cheques.
Even if an estate left someone with a five figure cheque, if you want to use that for housing it makes little difference. You could probably have made the deal work without it. Stick it in the markets and maybe you'll get lucky and build the war chest for the next generation. If you truly want multi-generational wealth as a legacy (which I'm not convinced is positive), the bulk of the money needs to be isolated and family only gets the authorized distributions. As soon as the principal is exposed, it won't take long for it to disappear.
Give someone 1M and most will blow quite a bit of it on cars/boats/trips/etc. Stick the 1M in a trust and distribute yearly 40K and grow ~30K and things may be sustainable. Assuming 25 year generations, capital in the fund ~quadruples each generation. That is assuming this calculator works properly. I couldn't bother to make my own and most do not allow yearly withdrawals. Seems plausible. Each generation starts drawing at 25 and gets their portion of the amount available to withdraw to keep 4% average growth up. In generation one, statistically, it will be two kids getting 20K a year each (taxable), in generation two likely four kids getting 40K a year each, gen three is eight kids getting 80K a year each. Obviously all non inflation adjusted numbers. None of the kids are getting rich off that but it may make the lives of all future generations easier. Just before gen 4 starts, there should be ~75M in the fund. Now, people get greedy and try and game the system. One kid could try to bang out a swarm to alter the familial distribution. Maybe limit each family to two units from the fund? Have more kids and they split the two units (eg 2/3 unit each if you have three).
Free investment calculator to evaluate various investment situations considering starting and ending balance, contributions, return rate, and investment length.
www.calculator.net
Edit:
Calculations above assume distributions between 25 and 50 and then they stop. Hopefully the kids invested along the way or they will be in for a rude awakening. They did get the money in probably their hardest years though to give them a head start. Gen one gets ~500K each, Gen two gets ~2M each, gen three gets ~8M each. All in current dollars, adjusting for inflation reduces the apparent disparity substantially.