@Wes Brand Risk is indeed king, even more so than cash flow. If a person is taking on too much risk relative to their tolerance levels, then they are making a risky decision even if it's something as simple as investing in a CD. The reason being people tend to not make good decisions when under stress due to financial risk. I'm not at the stage where I could tolerate the risk associated with an appreciation play. I plan on researching in that direction, and I don't intend to pursue lower end rentals for the potentially high CoC returns. I'm going to try and settle on a happy medium, but as of now my appreciation predictions are at inflation. I might experiment by forcing appreciation through improvements to a property, though.
As for whether or not your deal is speculative, I guess for me it would depend on how much of your total portfolio this deal constituted. I see it as speculation if it's very high return (you mention potential 100% CoC) and it would cause you to lose a significant portion of your total net worth if your market predictions weren't correct. This is even if you have the alternate source of income to bail you out.
I think every extra percentage point of return an investor gets over time is probably going to have to be fought for in the form of risk and hard earned knowledge. I think it's very rare that a person can consistently generate extremely high returns, but I do acknowledge there are certainly those that do. I also know that plenty fail, even though they tried as hard as anyone else. It comes down to how much money do you want/need? For my goals I need 10-12% real returns over time. I don't need high appreciation to achieve that. If my needs or opinions change, and it has room in my portfolio, then I will pursue it.