If you like grounded sci-fi that elicits a “it could happen in a few years” vibe firmly rooted on Earth, check out William Gibson. Most of his stuff is excellent, but “The Peripheral” and its followup “Agency” are recent highlights. From his older stuff I very much enjoyed “Virtual Light” the most. More than his acclaimed “Neuromancer” (he invented the word cyberspace in 1982 and popularized it in this 1984 novel) even.
Neal Stephenson - “Seveneves” One of my all time favorite sci-fi books. It is set mostly in space, but very realistic and never leaves the Earth’s influence. Time setting is basically now or a few years from now.
Also by Stevenson: “Anathem” Marvellous alternate universe story with a few twists. It’s on Earth, just … different.
If you wanna go for the classics (1960 roughly), look into Stanislaw Lem. “Solaris”, “Eden” and “Transfer” all left a lasting impression on me.
As an avid Dune books reader (all of them), I think Villeneuve did the best adaptation possible. As a character, Chani is much more fleshed out in the films and Rebecca Ferguson CRUSHED it as Jessica. Oscar Isaac also was a very good Leto.
My big gripe is with Stilgar and Paul. Stilgar in the second movie was almost relegated to comic relief. Yes, he is also portrayed as a believer in the books, but it felt like a caricature in Dune Part 2.
As for Paul, I had hoped for more focus on why he actually went to drink the water of life. In the books he wanted to avoid it. But events he couldn’t foresee and put people he loved in danger pushed him over the edge. In the film I didn’t get any of that.
Still, loved both parts. Definitely worth a watch.