Unless you have at least $1M - forget about it. Using a US LLC with a foreign legal entity as a member is also not a good idea due to the branch profits tax. However if you insist on using a US LLC I think this could be solved by using a trust instead of a foundation.
Look into UAE - it might be better to just set up everything there, with substance and local banking of course. So an ADGM/DIFC foundation + FZCO. An alternative would be to have an independently owned OpCo which would lease assets from a foundation, although I'm not sure if that would work in practice.
What's your tax residency btw? As Martin said a few months ago all structures in 2023 need substance, however a foundation is a problem by itself as some countries don't recognize foreign foundations at all. So it is not only a tax but also a legal issue. And if you need to go with a Liechtenstein foundation (due to DACH residency for example) costs can go up quickly.
e.g.
https://blumgrob.ch/wp-content/uplo...foreign-family-foundations-in-Switzerland.pdf
Foundations also differ between jurisdictions which needs to be taken into account of course. See this for example:
https://www.ius.uzh.ch/dam/jcr:2c894a3c-b7d7-4f9d-ac0d-d514a3349dbb/Noseda_Common Law Foundations - A Successful Experiment.pdf
https://www.linkedin.com/pulse/comparison-foundations-difc-adgm-rak-icc-hanafin-tep-chartered-mcsi/