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.
The first two thirds of Seveneves is really good at exactly what you describe. Once you get to the third part (you’ll recognize it) just pretend the book ended before that.
I was the opposite. The first 2/3 was a slog to get through to reach the inevitable. If people enjoy doomsday scenarios it’ll work for them, thouugh. The last 1/3 was when everything got really interesting for me and ended way too soon.
Seveneves was a wild ride, and I appreciated the way its scope broadened, but I definitely wasn’t expecting it.
I liked the third half. But it’s quite a shift