The Old "Dune" was awful too !
I read foundation a while ago... I'll wait. I do like Villeneuve. I' did love Arrival.. even after many viewings.
I rather liked the old Dune, agree on Arrival.
Other SciFi movies I think were good adaptations
War of the Worlds (2005)
John Carpenters The Thing
The Martian
The first Star Wars installation though one could argue it wasn't really a book before it was a movie.