This is a question that comes up often. Do I trade what I perceive to be more tenant headaches and less appreciation for cash flow today? Or do I deal with "nicer" properties, and presumably "better" tenants, and sacrifice cash flow for less hassle and more upside appreciation?
And if one assumed that the second plan would really pan out as expected, I think many people might sacrifice that short term cash flow to near break-even, if we thought we'd end up with nice house fully paid for by someone else, at which time we're just collecting rents. (And in some markets, that's almost your only option. The 2% rentals just aren't anywhere to be found.)
For me, I think you have two things figured out before you decide which route to go are these: (1) Know your exit strategy before you buy a property. If you have no plans to sell, ever, why focus on appreciation? Appreciation just means higher property taxes. If you plan to sell at some point, though, you need to know what kind of buyer that is, and then ask yourself if your property will have appeal to that kind of buyer. (2) Become a master at tenant selection. This is where you'll determine whether you're going to have a headache or not, regardless of the property's value, location, condition, etc. I've had tenants in "sketchy" neighborhoods that pay on the 1st of the month like a Swiss watch, without bothering me for anything. They are out there if you know how to find them.
I have a "nicer" rental that is as close to hassle-free as it can get. The tenant never bothers me for anything. He pays five days early each month. And even on that rental, over the last 29 months (since it became a rental), my expenses, including a capital expenditure for replacement of an A/C unit) are running at 30% of my rent. If I add in 8% for vacancy and 10% for property management, BOOM, I'm right at the magic 50% number that is talked about here -- and I'm telling you, this is the easiest rental property I have ever had.
It sounds like you're going to be highly leveraged (you're borrowing the down payment), so your strategy is likely, "Try to keep this sucker cash-flow neutral while I pay off the loans, then enjoy the property debt-free later." I don't know what your cost of funds is, but you might be able to do that if you choose the right tenant.
Figure you're renting it for 12% of its value each year. Back out a vacancy expense equal to 1% of its value, taxes equal to 1% of its value, insurance at 1/2% of its value, and repairs and maintenance at, say, 2% of its value, and you have a 7.5% ROI. As long as your cost of funds is less than that, you should be able to break even cash-flow wise when you add in principal amortization.
I know there are those who will think this is a loser, but if you can get good tenants in and manage your expenses, you could be sitting on a house that is fully paid for in 15-20 years using someone else's money. And that ain't all bad.