If you want science and technology to be as “realistic” as possible, only near-future stories will provide that … with a view exceptions.
A fascinating one is “Evolution” by Stephen Baxter that recounts the history of our ancestors from the distant past when dinosaurs ruled the world to a future that shows an earth that has lost almost all of its capacity to keep life going.
The book is very speculative, of course, but the science is solid.
The same can be said about other books by Baxter and also about Greg Bear, Greg Egan and Alastair Reynolds.
All these authors make an effort to show technology that is grounded in science; their work tends to focus on its implications on human life and culture.
Other authors create “realistic” looking scenarios by concentrating more on “soft sciences” and social and psychological dynamics, technology is not the mover of things.
I very much liked “Eifelheim” by Michael Flynn. It tells the story of crash-landed insectoid aliens in a medieval German village and some present day scientists who discover that such an encounter happened.
David Brin’s Uplift Trilogy is more a space opera but it blends the “technology as mover” idea pretty well with a focus on socio-political dynamics in a universe that is crawling with intelligent life … life that has been made intelligent by older races that in turn had been “uplifted” to intelligence by even older ones.
The humans seem to be an exception: either the race that uplifted them is unknown and has abandoned them or they actually evolved naturally … an idea that threatens many established beliefs and therefore leads to conflict and chaos among the intelligent races.
But quite a lot of technology in Brin’s work follows Clarke’s third law of prediction, so you might not consider it realistic enough.
Otoh, weird or inexplicable consequences of far advanced technology are, imo, in a way more realistic than the logical, clear-cut impacts that authors like Asimov or Heinlein show.
I think that’s why I like “Roadside Picnic” by Boris & Arkady Strugatsky so much; it shows what happens when present day humanity came into contact with the remains of a technology that is so far ahead of our own that we can’t even begin to understand what we are dealing with.
It’s pretty much a “cargo cult”-story: we see the effects but we don’t know where they come from or how to control them.
In this book, the word “alien” actually means what it implicates.