Your math ignored both maintenance and property tax on the home. Let's say maintenance costs 1% a year and property tax is 3.5% a year. I'm choosing both numbers lower than likely reality to give your position an advantage and let's say that advantage covers any income tax benefit of paying the property tax. After those 30 years you have a $1214 asset that you've put a bit over $1170 into - that's the original $100 plus about $238 in maintenance and about $833 in property taxes. So your $100 investment has grown by about $44 while the stock investment in your example, after deducting 20% in cap gains, has grown by about $114.

The house by itself is a bad investment, factoring in mortgage interest makes it even worse, then factoring in not paying rent makes it significantly better. How much worse or better it is in the final analysis depends on factors that are outside of many our controls - jobs, family, local market, etc. The decision is not quite as cut & dry as many on this thread make it out to be.