There's really no way to design a maintenance-free house. A typical house has a lot of parts slowly failing all the time, meaning you will eventually need expensive repairs on various timelines (sometimes many years, so it can be "ignored" for a while at your peril). Roofing, HVAC systems, sheetrock damage, repainting, replacing aging flooring/carpeting, replacing failing major appliances, etc.
You'd have to design and build a custom home way outside of the designs considered normal for the market to make it significantly more (but not completely!) maintenance-free in the long run, at a significant increase in construction cost. But then you've subjected yourself to another hidden downside: the more strange/custom/expensive a home is, the less liquid that home will be on the market if you decide to sell later. A home that's awesome to you but not-awesome to 95% of the market doesn't move. And if you're stuck with it and it's a significant chunk of your wealth, then you can't move cities for that new job or whatever.
You'd have to design and build a custom home way outside of the designs considered normal for the market to make it significantly more (but not completely!) maintenance-free in the long run, at a significant increase in construction cost. But then you've subjected yourself to another hidden downside: the more strange/custom/expensive a home is, the less liquid that home will be on the market if you decide to sell later. A home that's awesome to you but not-awesome to 95% of the market doesn't move. And if you're stuck with it and it's a significant chunk of your wealth, then you can't move cities for that new job or whatever.