But, if the buyer is looking at homes for investment purposes, the amount of money put into fixing a foundation issue could destroy the investor's return and any potential for profit on the project.

Is a good tenant absolved from their responsibilities when they break a bay window with a ball, set the kitchen counter on fire, flood the bathroom and destroy the down stairs ceiling, set fire to the carpet, back their car into a garage door, no of course not.

Why buy it on a house that's even less likely to be completely destroyed.

I have faced the same negativity in my current field and have consistently destroyed my competition year after year.

You will likely lose their money and potentially destroy relationships that could serve you well in the future, after you gain that valuable initial series of experiences. 

my health , home and family and pets all destroyed!

That's why most of us would advise you go for at least C+ areas and avoid the war zones because paper profits is different from actual profits if you can't rent out to people who can pay on time, or won't destroy your place.

I have seen many people being destroyed financially with risking all in real estate.

It can destroy your relationship and cause you to lose a buyer.** If you have access to an investor friendly agent get expired listings for MFRs and offer them a similar reward as above at the closing.

Also, let's say you  buy the property and just can't seem to find decent tenants who actually pay you on time, and take great pride in destroying everything in the unit.