I don't know anything about the longevity of a light frame construction building but how will homes built today look like in 30 years? Those McMansions don't look so sturdy.
My house was built in 1977. It is 1 year older than I am.
I had a broken hot water pipe that needed fixing last week... but other than that it is perfectly sound.
My house is predominantly seasoned 2x6 construction, though. Most McMansions and cookie-cutter neighborhoods nowadays use green 2x4's or sometimes even 2x3's.
My parents' McMansion (2800 sq ft, 3 car garage, late 1990's construction) has visible twisting of rafters and studs under the drywall, and even a couple places where the drywall is starting to separate.
It isn't going to fall down as a result of that, though. If they get really annoyed by the twisting they can have someone come in, replace the warped stud with a new one and re-drywall over the hole. It'll cost a couple grand to have that done, but it isn't an inherent structural issue. Just cosmetic.
The premise of a house as an "investment" is so faulty I can't even begin to tear it apart. A person HAS to have a roof over their head to provide for his safety and the safety of his family. You either rent, and pay the costs of maintenance as a function of free market rent prices, or own, and pay the costs of maintenance out of pocket as they come up.
The best part of a house as "investment" is if you stay in it for 20+ years. As our annual 3% (yeah, right) inflation kicks in each year, that mortgage payment is locked in and becomes a smaller and smaller piece of your monthly budget. With rent, it gets adjusted upwards every contract renegotiation.
My parents used to pay about $750 a month for our house in Minnesota in the late 1980's. I wish my mortgage were that low.
But, my $1150 mortgage right now will feel much lighter in 15-20 years.