For home sites, the bottom line is pretty simple: You want soil that has good bearing capacity, exerts relatively low lateral pressure, and drains well, so that you can have a stable, dry foundation. The best natural soils for these purposes are sands and gravels. Silts and clays are fair, but the softest ones are poor. Then there are soils such as peat, expansive clay, and improperly deposited fill, which are so bad that they must usually be removed and replaced - often at considerable cost to you.
Many of your questions should focus on potential problems and maintenance issues. Does anything need to be replaced? What things require ongoing maintenance (e.g., paint, roof, HVAC, appliances, carpet)? Also ask about the house and neighborhood, focusing on quality of life issues. Be sure the seller’s or real estate agent’s answers are clear and complete. Ask questions until you understand all of the information they’ve given. Making a list of questions ahead of time will help you organize your thoughts and arrange all of the information you receive.