It wasn't about Foundation, then why call it "Foundation"?
It's like that Will Smith movie called I, Robot: why did they bother calling it that?
You can create a new sci-fi show or movie without the 'false marketing' of referencing previous source material: that's what the original Battlestar Galactica and Star Wars did in the 1970s. Or you can try to faithfully use the source material as much as possible as The Expanse show has done, and what Villeneuve has generally done with his Dune.
There are plenty of both sci-fi and fantasy works available for adaptation into shows and movies. And if (general) audiences expect action-y stuff in their sci-fi/fantasy, then pick one in which the source material is more action-y.
Don't try adapting Waiting for Godot into the next Die Hard.