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.
Neal Stephenson’s Seveneves has a lot (A LOT) of orbital mechanics jargon if you’re into that sort of thing. Personally, I skipped most of it.
His explanations are why I read any of his books. I find his prose dry and bland, even if he’s telling an interesting story. I stay for the fun facts.