In hindsight, I should have purchased sewer insurance right out of the gate (if they offer that where you live) or at least, had the line camera scoped so I could see what it looked like.  

Understandably distraught, they left the next day. 

I probably would have returned all,  epsecially if tenant had a good 10 year history, unless they left the place beyond repuslive or damage with intent.

You've come to the right place!

Right now, it's clear you aren't looking at properties in real life, so it's not surprising you are stuck in analysis paralysis.

Would you recommend the Detroit area to be a good investment right now as I live close to it?

Run right, well they are incorrect.

As it relates to the up-and-coming neighborhoods there are 5 that I would point out as good investment opportunities      Northend- This is an area right along the border of midtown.         

Yes an attorney can pierce your entity if it's not set up right or you're not in compliance. 

They will offer to do maintenance and then do it poorly, if at all.If you want to rent the property, do the right thing and fix it up.