In signing this Lease, Tenant agrees that Tenant has examined the Premises and certifies that it has not observed any pests in the Premises

To understand the value of your land on empirical basis, you need to understand the "Whole" (the project) in order to understand the "Part(s)" (land value).A closing observation: the value of your land can and should be understood and viewed in relative terms.

During a site visit of the premises, I observed hoarding conditions of my newly renovated unit. 

You would be, as you observed, a "speculator".However, the ones that can tell you which of your numbers matter, and how much they matter...if at all, are the owners and tenants. 

I’d really love to work for/observe and learn from someone already in the game, but obviously don’t want to be scammed or taken advantage of.Anyone have any insight?

Not recommendation by any means, just observation!

Some foreclosure auctions do not offer agent commission.Your best bet is to attend few auctions, observe and ask questions to local investors in your area.

I haven't done any business with them but based on my observations of the properties listed on their site from the Cleveland market they aren't adding much if any value other than a nice website.

Would make some more observations.

This is an interesting observation.