It was very much a product of its time. It was alright.

It's good if you want something more 'close to the books' story wise.

However, the Harkonnens are quite dialed back (they always are). And everything is low budget.

But personally, I enjoyed it and still re-watch it from time to time.

It's enjoyable if you watch it in the context of it's time. You can't compare it to the Villeneuve version.