As an example, I love the Martian, and I think a lot of older books from authors like Asimov are heavily into engineering / competence porn. Other favs in this category include the standalone novel Rendezvous with Rama to leave you wishing for more, most of the Culture series for happy utopian vibes, Schlock Mercenary for humor, Dahak series for fun mindless popcorn.
Edit: I’m so happy to have found a replacement for r/books and the rest of them.
You will. The Great Silence was very poignant. But yeah, there’s a great variety of stories.
I’m just starting The Apt series (guess I’m doing Tchaikovsky in reverse) end will finally get to the children of time series when I can get it via my library or I might just bite the bullet and buy the audiobook.