Everything depends on the deal. Plain and simple.
As someone mentioned above, people tend to overcomplicate the process or the goals on what they're looking to achieve.
House hacking solves two "problems"
1. Being able to subsidize your mortgage payment so you can effectively pay less for an appreciating asset than everyone else.
I.E., you get a 600,000 mortgage, but only have to pay a third or a quarter of that mortgage payment due to the income from the other units. You are minimizing your input to maximize your output (output being an appreciating asset, paying down principal, tax benefits.
2. Like many people on BP, they want to make this a future investment property and want to see an ROI on that investment.
ROI can be seen a few ways, and you need to define that.
Is it immediate cash flow? Then you need to employ the tactics of a value add real estate investor. You need to focus on negotiating and sourcing good deals. That takes work, persistence, and some strategy. Just going on Zillow and offering at retail price is not going to get you immediate cash flow. You need to put effort into finding distress.
If its' long term appreciation (which I'm personally not a fan of betting on) you can look at it as, if you put a small 3.5% down payment using FHA or Fannie Mae, and your property appreciates on average at 3% a year. In 10 years, you've effectively 10x'd your initial out of pocket, not including the pay down from the tenants.
Again, to keep it simple:
1. Define your goal. Is it to be an investor or just subsidize your income?
2. If its to be an investor, you need to put more effort into finding good deals. ROI doesnt come from buying retail. It comes from buying distressed assets and fixing them or re-arranging the property to make it perform again.