I picked a random house in Southern California, it is up 42% in the last 10 years, sounds great, right?
But that is only an annual rate of return of 3.572%. Nothing at all exciting.
Where it becomes exciting is where you bought that $500k house ten years ago with $50k down, and sell today for $800k - ignoring everything else like taxes, etc, you made $300k on a $50k investment (leveraged) - which is an 18% a year return. THAT is something to take notice of! Of course, you have to factor out all the associated costs, but the leverage is the be-all and end-all of your "investment". If you could leverage against stocks the way you can against single-family houses, you could go nuts.
The advantage to leveraging real estate that you live in is that you basically have a heads I win, tails you lose scenario; if the house crashes you walk away (at least in non-recourse states like California, and practically almost everywhere).