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.
Recently, I’ve been reading the Interdependency series by John Scalzi. It starts with The Collapsing Empire, featuring an unlikely heir to the throne, a time of trouble and strife, and the likely impending doom of all mankind. A lot of the story focuses on the unlikely heir grappling with how to hold things together against the catastrophe that most people don’t really believe is coming.
Looks cool! I enjoyed Scalzi’s Old Man’s War series, will be nice to visit him again.