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.
Oh, certainly. In case it’s helpful, here’s a post I made last spring with notes from a year of reading - it’s pretty much all SF and fantasy. Many of the books mentioned in this thread are there. I’ve been reading about the same amount since, and will probably do another post on the anniversary of that one.