Lots of great insight from the folks above.
In my experience as an investor and multifamily lender in the twin cities, I would simply say there is no "right" answer. I have seen people do this a variety of ways and you should assess it more on a case-by-case basis. My own personal househacking progression was SFH, SFH, Duplex, SFH, Duplex. Since then, I have been able to leverage equity from those to finance non-owner-occupied deals. Cash flow on each have fluctuated. I have a tenant going on his 8th year in my duplex, meanwhile one of the SFHs have turned over almost every two years.
I agree with the pros and cons above - one thing I don't see listed yet is how the property type last purchased affects your ability to buy. For example, if you start with a big single family home in the suburbs, then want to hack a 4plex in Minneapolis the following year, there will be questions regarding your true intention to occupy that 4plex as your primary. Not impossible - but a hurdle, indeed. Generally, for this reason, it's best to move from more units to less.
I would say, keep your options open and assess the deal presents itself!