I recommend you hold your cash position for 12 months.  

Right now, the best offers around me are for some 1.3-4 million, that only generated around 100k per year gross, so there would be a high chance of not cash flowing, and paying money, especially with a commercial loan (these buildings have more than 4 units).I was thinking that although the rental itself does not generate money, I would be able to deduct the mortgage interest, and depreciation from my personal w2 income and would be net positive.

South End is great for appreciation-driven investors who want to be close to the action.NoDa (North Davidson): The artsy vibe and walkability have made NoDa a magnet for young professionals, driving appreciation in this district.Kannapolis: Known for ongoing revitalization projects, Kannapolis is positioned for appreciation.

that we’ve learned in our 24 years, managing almost 700 doors across the Metro Detroit area, including almost 100 S8 leases:Class A Properties:Cashflow vs Appreciation: Typically, 3-5 years for positive cashflow, but you get highest relative rent & value appreciation.Vacancy Est: Historically 10%, 5% the more recent norm.Tenant Pool: Majority will have FICO scores of 680+ (roughly 5% probability of default), zero evictions in last 7 years.Class B Properties:Cashflow vs Appreciation: Typically, decent amount of relative rent & value appreciation.Vacancy Est: Historically 10%, 5% should be applied only if proper research done to support.Tenant Pool: Majority will have FICO scores of 620-680 (around 10% probability of default), some blemishes, but should have no evictions in last 5 yearsClass C Properties:Cashflow vs Appreciation: Typically, high cashflow and at the lower end of relative rent & value appreciation.

It has been frustrating but it also is a positive as I now can quickly know what deals to not even waste time on analyzing. 

By house hacking, you're immediately positioned as a landlord, which will adequately pressure you to learn how to structure your leases, screen applications, collect rental payments, resolve the nuances of managing tenants and addressing property issues, etc.

So, your focus may need to pivot from high rental cash flow to little to no cash flow as a rental with an appreciation upside.I would recommend taking your $150K to $200K and securing a solid equity position in something that will cover its expenses and maybe provide a small cash flow, but then is poised to appreciate nicely over the course of the next several years. 

There was positive population growth, medium home price growth, low unemployment, good rent to home ratios, and low crime, all of which are factors when I start looking into an area to invest in.  

that we’ve learned in our 24 years, managing almost 700 doors across the Metro Detroit area, including almost 100 S8 leases:Class A Properties:Cashflow vs Appreciation: Typically, 3-5 years for positive cashflow, but you get highest relative rent & value appreciation.Vacancy Est: Historically 10%, 5% the more recent norm.Tenant Pool: Majority will have FICO scores of 680+ (roughly 5% probability of default), zero evictions in last 7 years.Class B Properties:Cashflow vs Appreciation: Typically, decent amount of relative rent & value appreciation.Vacancy Est: Historically 10%, 5% should be applied only if proper research done to support.Tenant Pool: Majority will have FICO scores of 620-680 (around 10% probability of default), some blemishes, but should have no evictions in last 5 yearsClass C Properties:Cashflow vs Appreciation: Typically, high cashflow and at the lower end of relative rent & value appreciation.

Like Devin said, double digit rates and you could still have fees similar to a first position mortgage.