Purchasing MFH is exciting because it's always nice to get 4 rent checks instead of 1. :) The one nice thing about MFH is that the interest rates are fixed for 30-years because they're not commercial.
The most important question to ask is: what do I want, and why?
Do you want to retire early or do you want to have a nest egg that appears to you in 20-30 years? Somewhere in between? Do you want to amass a large real estate portfolio and grow it indefinitely?
First thing's first, you really buy places that will positively cashflow, even if it's not great. Never lose money on a property every month and hope that increase in value will save you.
There are quite a few reasons to buy a place & hold a place to make money
* appreciate with the market
* force appreciation with upgrades (BRRRR or flip)
* Cashflow with large increases in rent
* Cashflow with small increases in rent appreciating with the market
There's probably more but these seem to be the biggest ones. Those are your options and they all have different goals and requirements for work on your part. Which one appeals to you the most?