What if you see a bunch of homes boarded up, the sidewalk completely overgrown with weeds, and the street’s asphalt cracking falling apart?

No one is perfect and issues sometimes fall through the cracks. 

IMO too many focus on location to much, sure you do not want to be next to a crack house, but price is key.

The walls can't be cracking and 1990's beige when you installed brand new hardwoods throughout.And, while new cabinets and counters and appliances are nice, if they are not well laid out, or you jam an island into a space that does not allow for stools to be pushed out, or the oven door to open because it hits a cabinet pull, that new kitchen is meaningless. 

It's a tiny yard. 

(I bought it for the land with intentions of removing the trailer and building tiny homes on it to air bnb) I understood that I was responsible for any back bills or liens associated with the properties, I was ok with that.

I've heard the same feedback from someone w/multiple tiny home airbnbs in Suches.

There is one or more sections of possibly damaged/cracked drain line found under the home as viewed from the clean out at the front of the home.

Also I did a tiny bit of research and it looks like the "insider circle" is actually just a collection of lists they compile for you.

I'd look for signs of arcing around those outlets.Other things I look for are how is the foundation, cracks in the walls (assuming lath and plaster), condition of the mechanicals, depending on what the house is built on, I may get a radon test done for the air and water (near me there is a lot of ledge, so radon is an issue in most homes).