Houses have many intangibles. The positive ones include covered parking, less noise, more freedom, enhanced opportunites for things like gardening or parties, etc. But houses also come with enhanced reponsibilities such as lawn upkeep, maintanence of the house, taxes, liability, etc. The intangibles will vary with each person. I cannot say if the benefits outweigh the additional responsibilites for you.
As for the economic picture, it isn't as rosy as people tend to claim, nor is it as bleak as the opposite side tends to argue. Someone above mentioned that houses historically return about 1%. That is true (although I think it was closer to 1.5% last I looked). Thus, your money will do far better if it were invested in stocks or bonds or just about any other reasonable investment. That is a very good reason to have a modest house, so you can keep your money invested elsewhere.
But, you must spend money on shelter. This isn't a choice between investing in a house and investing in stocks. No, it is a choice between investing in a house vs using that same money towards apartments. If you only look at the first few years, the apartment argument almost always wins. But, Steppinthrax, try looking at the bigger picture. I'll roughly estimate what your costs would be in both situations.
5 years ago: apartment $600/month, house $1200/month (interest + principal + taxes + insurance).
Today: same apartment $729/month, same house $1200/month.
So far, it looks like the apartment wins hands down. But keep looking forward.
5 years from now: apartment $977/month, house $1200/month (interest + principal + taxes + insurance).
10 years from now: apartment $1247/month, house $1200/month.
15 years from now: apartment $1592/month, house $1200/month.
20 years from now: apartment $2031/month, house $1200/month.
25 years from now: apartment $2593/month, house $1200/month.
Hmm, things have changed a bit. But wait, after 30 years, if you kept the same standard of living, you'll have your house paid off (even if you move, as long as you don't cash out your equity).
30 years from now: apartment $3300/month, house $400/month (taxes and insurance only).
35 years from now: apartment $4224/month, house $400/month
40 years from now: apartment $5391/month, house $400/month
This is where you can see the advantage of home ownership economically. You can be retired and paying over $5k a month for that same apartment that you used to rent, or you can own your house outright and pay next to nothing when you are retired.
But, to gain the housing advantage, you need a modest and reliable home (ie do proper maintenance). If you get the most expensive, largest house, in the best neighborhood that your bank will allow while constantly renovating it with fads such as stone countertops, shag carpet, stainless steel appliances, popcorn ceiling, open floor plan, closed floor plan, etc, then you'll likely never break even on the house.