Hey Shelton
Great question, and as always, the frustrating answer - It depends...
I'll share two of my experiences for context and maybe this will help in some way. When I moved to Toronto years ago, I found that rents were more expensive than cost to buy (assuming you had a down payment). In that market, I found a duplex where I wanted to live and house hacked. It worked out well and I learned many important lessons.
Many years later, I moved to a different town in BC. Here, I could not find any suitable duplexes and could not afford larger multis. It was also tricky to find cash flowing properties. My partner and I found a small 2BR/1BA, simple house that looked like it could be a decent rental one day. Not our dream home, but a good place to live for a few years at a reasonable cost (well less than what we could have borrowed). We were able to save up another down payment within a year and purchase another property as a rental when we did finally find a deal that cash flowed. 5 years later our market took off, rent prices included. Because we had bought such a cheap primary residence, we were able to hold on to it and rent it out with a large margin of cash flow. We've used that cash flow to help fund a much nicer property to live in and now have 2 rentals in this market.
My point here is that you can take what your market is giving you. Don't fight it by just deciding to buy a multi or to house hack. What makes the most sense in your market? What is going to make you happiest? I learned pretty quickly that I did not want to see my tenants every time I left my house in that Toronto property. Also, if this your first purchase, don't get too bogged down in the details or trying to make it perfect. You may not knock it out of the park on your first investment, but if you buy smart using what you learn from BP, it will likely set you up well for future investments.