Finally, a question on HN I am "qualified" to answer. During my university education I came across Structures[1] by J.E. Gordon who, unlike me, was an aeronautical engineer but his take on structures really made so much sense to me, as a student of engineering, in a way that the fustian delivery of the professors at college did not. Some books stay with you for life - this one did for me.
I can confirm that this book made me interested in "real" engineering (as in, engineering physical things in the real world rather than abstract symbols) when I read it. A bit too late for a career change, but I have talked to a few other people who hold this in high esteem as well. Good recommendation!
[1] Structures: Or Why Things Don't Fall Down by J.E. Gordon. Goodreads link: https://www.goodreads.com/book/show/245344.Structures