Not quite the same thing as you are asking, but a friend of mine made a mint selling his computer company to Microsoft in the 1980's - he'd got into the field before home computers were a thing. Anyway, he made £millions, and then made even more investing it well. He didn't set his children up financially - quite the opposite.
His children grew up with good parents, the best opportunities that money could buy, but definitely not spoiled - so no excesses etc. But by the time they were teenagers every single one of them (3) started to go off the rails and become, frankly, nasty selfish louts (at best) with appalling attitudes and serious issues - sex, drugs and rock 'n' roll doesn't really cover it. Expelled from multiple schools. Why - because they "knew" that their parents were so wealthy that they didn't need an education, didn't need to work, and didn't need to make anything of themselves. Even when the parents threatened to cut them off and out of the will, they "knew" their parents would never do that.
They have all been disinherited and all their parents money is being left to charity. The children know, but it hasn't made a jot of a difference to their behaviour because they are now pretty much useless for anything - 2 have multiple convictions for drug dealing. Their parents set up an "emergency trust" which will be managed independently and which will allow for certain support if the children want it - but that is restricted to things such as medical interventions, counselling, and things that will either prevent harm or enable them to turn their lives around if they choose to do so; they will never receive allowances or money directly. It broke their parents hearts to do this.
Both parents wish they had never made the money. They were both aspirational and hard working, but none of that has rubbed off on the children because they treated an easy life as an entitlement. So no - having seen this over the decades, I do not think setting up your children to never have to work is a good idea. Humans need motivation and goals. There are ways of easing the path to help children to grow and develop, but too much is, in my opinion, worse than not enough.