I watched season one of Foundation but didn’t particularly enjoy it, although I’ve always been an Asimov fan. Haven’t watched any of SILO as of yet. Also didn’t enjoy season one of Invasion. Found both Foundation and Invasion to be very slow, indeed boring at times, and the acting less than riveting.
Have you watched any of For All Mankind? That was a “slow grower” on me, was very glad I persevered.
Overall, I think many of the Apple TV+ originals are excellent. Some of my favourites are Severance, See, Black Bird, Slow Horses, Bad Sisters, Tehran and the truly wonderful Ted Lasso.