I knew going into the home buying process that ROI on a primary residence isn't going to come close to what you can get with basic low-fee stock funds, so the less you invest in a home, the better, over any reasonably long time horizon. Then you need to consider the sliding scale of paying less upfront versus maintenance. Owning equity in a home is generally for suckers who still value living the American dream.
Currently, it is doing good for my mental health as the stock markets plunge, and I do see some long-term diversification value in the asset. The tax treatment is also phenomenal, with no taxes up to $500k gain for married filers and stepped up basis upon death (stocks have this too, but I think it's infinitely more likely that step-up gets eliminated for stocks during our lifetimes than for residences). I think if you bought a house at some point in the COVID/slightly pre-COVID era, it's close to a wash with any total market stock fund at this point, up to $500k in gains. Definitely the best play would've been an interest-only mortgage at 1.5-2.0%, though. Lenders must be irate when they see a $5M mortgage on their books that they're collecting 1.5% on over the next 25 years.