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.
Greg Bear - EON but more maths heavy, and has a bit of politics but a very good read
Larry Niven - Ring world series (maybe not competence focused, but strong science backing)
Yep, added EON to my list based on the numerous recs here. Ringworld I’ve gone through, it’s such a classic!
Protector and sequels, too. I also liked Integral Trees, but maybe a little less so.
Yeah, isn’t protector part of the Ringworld series? A kinda prequel? I did love it, makes me feel better (or worse) about my aching joints. Haven’t read Integral Trees yet.