Lease Commercial Space While Living in Attached Apartment

I'm in the process of rehabbing my first single family purchase in Northwest Indiana to be used as a buy & hold and I'm already thinking about where to go from here. Part of me wants to stick with buying distressed single family and use BRRRR strategy, but I've also been interested in commercial real estate.

I would really like to find something, for example, which had some office space on the ground level, and a couple apartments above, one of which I could live in.  Has anyone had success with this strategy?  Are there any considerations to think about when doing this?  It seems like a great blend of house hacking with breaking into commercial space, but I'm sure there are some cons to consider as well.