Hey @Ashley Dixon great question.
I guess, first question is, how are you planning to purchase? Owner-occupant vs. an investment purchase can greatly impact your monthly cashflow prospects.
Now for your question(s): cashflow is more of a present to near-present focus while appreciation is more of a castoff into the future projection, in theory. Now, the right buy can do both, but to your point, it's possible there could be sacrifices made for one over the other for a time. Your appetite for how you'd like that ratio to trend will depend on your finances, etc.
Focusing more on the appreciation portion, that can be a challenge to project. A lot of factors can impact that, but to simplify, focus on targeting desired pockets that have a finite amount of geography and you'll highly likely enjoy ample appreciation over time.
Now back to cashflow, small multifamily may present better for you or the ability to add doors to a lot. That being said, anything you can buy under market will create a healthy margin for you in the beginning. If you can check that purchase box off, great. From there, I'd also make sure I targeted a neighborhood where you have a clear line of sight on how to push your property position up, to achieve top of the market rents (again focus on margin). Again, you'll need to pull a few levers to create cashflow, especially with a SFH, but it's possible.
Shoot me a note if you'd like to connect!