You need a house, so an affordable house would be fine, one that you cant afford isn't.
Yes an appreciating asset shifts the balance somewhat, but doesn't inherently make bad debt good.
I suppose its best to look at where each outlook ends up? The appreciating asset = good view would suggest you buy the absolute most expensive house you can get. I would suggest you look at what you need and actually can afford.
Edit: Spelling