You have not read much SF, have you? Sturgeon's Law [1] was created for a reason. If you think this is as bad as SF gets, I turn your attention to Robert A. Heinlein's "To Sail Beyond the Sunset".
Perhaps you prefer "cowboys in space", like Star Trek, Star Wars, Terminator, or Firefly.
Just for example, Greg Egan's written some of the most far-out sci-fi Ive ever read, eg. Dichronauts describing life in a universe with different geometry to our own + symbiotic intelligent lifeforms that can each percieve space on different axes. https://www.gregegan.net/DICHRONAUTS/DICHRONAUTS.html
The Martian was OK, good on the science mostly, but ultimately it's just a biography with not much to say about the impact of technology on the human condition.
Forward isn't much of a writer and his ideas are too much weed. Baxter and Robinson I haven't read. I think I started something by Robinson but gave up. And I can happily read Graydon Saunders. (Yes, fantasy, but well written).