Of course, with an interest-only mortgage, yes one would need to be cash-flow positive, because there is no such thing as gaining equity. Again, my understanding is that such properties are extremely rare.
When I say you "always want a mortgage" I mean that if you have a mortgage you have your tenants paying for the house. Your cash on cash return is far higher. If your potential property doesn't support that, then find another property. Paying $200k cash for a house that nets $500 per month is far less interesting than buying 10 houses at $20k down that each net $200 per month -- and it takes exactly the same cash.
EDIT: Here's a fun Reddit thread on the topic:
https://www.reddit.com/r/RealEstate/comments/36ikp6/landlord...
Here's an example from that thread on how quickly the math takes you to roughly cash-flow neutral -- and this is with 25% down and 1% rental price:
https://www.reddit.com/r/RealEstate/comments/36ikp6/landlord...
However, I think that's unrealistic, I believe the demand for my house would be extremely low at that price point. My house is very appealing for residents, I don't see it being particularly appealing for travelers and there's cheaper options for travelers.
My neighborhood is zoned residential, however, so I seriously doubt turning it into a hotel would be legal. My neighbors would complain as well (and that's nothing against them)
[1] - https://docs.google.com/spreadsheets/d/1rCz54o_8Z_9fMkPQyTTZ...