It’s definitely more interesting in the way that Herbert “directed” the narrative camera, in the book you jump from mind to mind in a way no previous book quite did. The plot itself is kind of just the bread for that sandwich
It "goes nowhere" because the world-building is the whole thing. Foundation is Technology; technology always has a purpose/telos. Dune is Ecology; ecosystems exist for their own sake.