As a structural engineer, I could bore you with all the design guides we use for residential or commercial construction, but if you really wanted to get some good sleep, you could look into the Residential Building Code for a deep dive into codes and standards for the construction of homes. I agree with Bruce though, experience is the most practical way to learn these types of things. Contact local pest control experts, contractors, home inspectors, etc. and ask the questions you want to know more about - this is what I have done. There's podcasts and books out there on home inspecting that can give you a broad idea of what to look for in newer and older homes, but nothing teaches you like experience. One piece of advice would be to make sure to find professionals that don't mind if you tag along and ask questions while they do their job. When I had a pest control expert come out to look under my primary residence, I crawled under there with him to look for fungus/mold, termites/ants, and water issues - I learned more doing that and listening to him than I ever have watching Youtube videos or reading forums.
If you have structural specific questions regarding conventional residential framing, wood/masonry/brick/concrete construction, or just general questions regarding the integrity of a property, shoot me a direct message. I can try to help in the areas I have suitable knowledge and experience. Full disclosure, I'm a structural engineer by trade, but I am not a licensed contractor or inspector, so always consult a professional before making any financial de