How to invest in a sellers market/Metro-Detroit

[Account Closed]

I've just joined this community and from the Metro-Detroit area. I should also mention that I am a realtor and have access to my local MLS; a significant advantage since I have immediate access to the sales data. Selling RE is not my full time job. I merely stumbled into RE about 6 years ago got the license and I have kept it active. Some sales here and there but not my bread and butter.

I currently live in a condo.  No mortgage.  I had a home I sold in 2016.  So I do have some capital saved up.  I have gone back and fourth, on these scenarios:

-Buying a SFH needing some light cosmetic rehab and living there.

-Buying a SFH needing some light cosmetic rehab and renting it. Live in condo.

-Buying a duplex/multiunit and living in one unit.  Sell condo. 

-Buy a duplex, rent it, live in condo.

The problem with most of these scenarios, is the market.  I recently went to an open house in one of the more in-demand communities for families, and I was talking with the realtor (Being a realtor, we talk shop from time to time!)  She actually told me that the house i was at already had an offer on it within hours that past Friday when it was listed on the market.  She also told me that she had some other buyers she had been working with and they are on their FOURTEENTH offer trying to secure a house for them  Overbidding and offering additional cash over appraisal as much as $5,000 and still losing out.  Obviously here there is an extreme inventory shortage.  So my question, when it's a sellers market and competition is this fierce, what investment scenario makes the most sense?