What a good question, Prudie.
As always, the answer is............ "it depends"
Theoretically... Atheist is quite right. Modern building regs and standards are very good. Way above historic methods of construction.
If...
Standards and regs are fully adhered to.
Good quality materials are used.
Site labour is properly paid, and not offered a pittance to undertake complex, time-consuming tasks which all too often result in hurried, below quality work.
Above all.. with good supervision from site agents and foremen (more often than not, the weakest link in the chain.)
That's a lot of "ifs", isn't it?
So, in theory, a modern building should last. As with everything, the wildcard is human nature, and you know how unpredictable that is.
I live in a house I built myself. I'm confident. Bur I'll let you know in a couple of hundred years from now ;o)